Introduction
Methodology
Results
Discussion
Conclusion
Appendix
There are cities like Jacksonville reopening beaches while Georgia is planning to reopen several businesses starting April 24th. Is this a good time to consider reopening with the risk to public health from COVID-19 or will there be too much economic damage if not? In order to answer the questions, I will take a look at county health population information from https://www.countyhealthrankings.org/ and business information(leveraging Foursquare API)in Jacksonsville, Florida and compare to Savannah, Georgia since they are large cities located in the neighboring states. The governers of Georgia and Florida should take these factors into consideration before opening their states among COVID-19.
I. Neighborhood Locations
I will be using http://www.city-data.com to get neighborhoods and geographical locations.
II. Foursquare Location API
I will explore business information such as number and type of businesses to see the type of impact closing the cities will have. I also want to see if there are nearby clinics, hospitals, and/or pharmacies to learn about capacity for handling rise in cases for decision in reopening.
III. County Health Rankings
I will be using county health rankings to get details about the population using information such as:
IV. Death Rates by Age
I will be using https://www.worldometers.info/coronavirus/coronavirus-age-sex-demographics/ to get
death rates by age.
V. Hospital Capacities
I will be using https://coronavirus.jhu.edu/us-map to get deaths, confirmed cases, and hospital capacity by county.
I. Access Foursquare API
In order to determine number and/or type of businesses affected, we need to explore Jacksonville and Savannah counties. We will access the Foursquare API to get business information
but first need to find all the nearby neighborhoods with geographical coordinates in each city.
Import necessary packages and libraries.
import numpy as np # library to handle data in a vectorized manner
import pandas as pd # library for data analsysis
pd.set_option('display.max_columns', None)
pd.set_option('display.max_rows', None)
import json # library to handle JSON files
!conda install -c conda-forge geopy --yes # uncomment this line if you haven't completed the Foursquare API lab
from geopy.geocoders import Nominatim # convert an address into latitude and longitude values
import requests # library to handle requests
from pandas.io.json import json_normalize # tranform JSON file into a pandas dataframe
# Matplotlib and associated plotting modules
import matplotlib.cm as cm
import matplotlib.colors as colors
# import k-means from clustering stage
from sklearn.cluster import KMeans
print('Libraries imported.')
conda update -n base conda
# conda install -c anaconda beautifulsoup4
import requests
from bs4 import BeautifulSoup
from requests import get
from requests.exceptions import RequestException
from contextlib import closing
import re
Generate credentials to access API.
CLIENT_ID = 'KTOGVYYQUEWMCLZYN3EHY3W1FJ2EUDJ1FIXZKSXQCWBXNQJA' # your Foursquare ID
CLIENT_SECRET = '01RRALCQSNM3UZKYRWZYBNMJL5O5TBFCCBRVKYI4XUA0MSWW' # your Foursquare Secret
VERSION = '20180604'
LIMIT = 30
print('Your credentails:')
print('CLIENT_ID: ' + CLIENT_ID)
print('CLIENT_SECRET:' + CLIENT_SECRET)
Your credentails: CLIENT_ID: KTOGVYYQUEWMCLZYN3EHY3W1FJ2EUDJ1FIXZKSXQCWBXNQJA CLIENT_SECRET:01RRALCQSNM3UZKYRWZYBNMJL5O5TBFCCBRVKYI4XUA0MSWW
Create function for getting neighborhood coordinates by city. The function webscrapes city-data.com to get neighborhood information by city.
def get_neigborhood(URL,city):
# URL = 'http://www.city-data.com/nbmaps/neigh-Savannah-Georgia.html'
page = requests.get(URL)
soup = BeautifulSoup(page.content, 'html.parser')
city_name = [tag.text for tag in soup.find_all('a',href=re.compile(r'#N\d+'))]
string=(','+ city)
city_names=[x + string for x in city_name]
column_names = ['Neighborhood', 'Latitude', 'Longitude']
# instantiate the dataframe
neighborhoods = pd.DataFrame(columns=column_names)
#apply Nominatim
geolocator = Nominatim(user_agent="to_explorer")
for i in city_names:
try:
location = geolocator.geocode(i)
latitude = location.latitude
longitude = location.longitude
neighborhoods = neighborhoods.append({'Neighborhood': i,
'Latitude': latitude,
'Longitude': longitude}, ignore_index=True)
except AttributeError:
continue
# making separate first name column from new data frame
new = neighborhoods["Neighborhood"].str.split(",", n = 1, expand = True)
neighborhoods["Neighborhood"]= new[0]
# making separate last name column from new data frame
neighborhoods["City"]= new[1]
neighborhoods2 = neighborhoods[["City", "Neighborhood", "Latitude","Longitude"]]
return neighborhoods2
Call function by city to get all neighborhoods, latitude,and longitude.
Let's start with Savannah.
Jacksonville='http://www.city-data.com/nbmaps/neigh-Jacksonville-Florida.html'
Savannah='http://www.city-data.com/nbmaps/neigh-Savannah-Georgia.html'
neighborhoods=get_neigborhood(Jacksonville,city='Jacksonville')
# neighborhoods=get_neigborhood(Savannah,city='Savannah')
# 'http://www.city-data.com/nbmaps/neigh-Jacksonville-Florida.html',city='Jacksonville'
neighborhoods.head()
| City | Neighborhood | Latitude | Longitude | |
|---|---|---|---|---|
| 0 | Savannah | Avalon | 32.050010 | -81.066843 |
| 1 | Savannah | Avondale | 32.052988 | -81.057612 |
| 2 | Savannah | Baldwin Park | 32.050870 | -81.091097 |
| 3 | Savannah | Bartow | 32.086596 | -81.124556 |
| 4 | Savannah | Bayview | 30.224534 | -85.682356 |
Next Jacksonville neighborhoods and coordinates.
neighborhoods.head()
| City | Neighborhood | Latitude | Longitude | |
|---|---|---|---|---|
| 0 | Jacksonville | Arlington | 30.335795 | -81.602871 |
| 1 | Jacksonville | Avondale | 30.304406 | -81.711209 |
| 2 | Jacksonville | Belfort Station | 30.251119 | -81.584455 |
| 3 | Jacksonville | Brooklyn | 30.323573 | -81.674541 |
| 4 | Jacksonville | Church District | 30.280525 | -81.490998 |
Use function to get nearby venues.
def getNearbyVenues(names, latitudes, longitudes, radius=1000):
venues_list=[]
for name, lat, lng in zip(names, latitudes, longitudes):
print(name)
# create the API request URL
url = 'https://api.foursquare.com/v2/venues/explore?&client_id={}&client_secret={}&v={}&ll={},{}&radius={}&limit={}'.format(
CLIENT_ID,
CLIENT_SECRET,
VERSION,
lat,
lng,
radius,
LIMIT)
# make the GET request
results = requests.get(url).json()["response"]['groups'][0]['items']
# return only relevant information for each nearby venue
venues_list.append([(
name,
lat,
lng,
v['venue']['name'],
v['venue']['location']['lat'],
v['venue']['location']['lng'],
v['venue']['categories'][0]['name']) for v in results])
nearby_venues = pd.DataFrame([item for venue_list in venues_list for item in venue_list])
nearby_venues.columns = ['Neighborhood',
'Neighborhood Latitude',
'Neighborhood Longitude',
'Venue',
'Venue Latitude',
'Venue Longitude',
'Venue Category']
return(nearby_venues)
Create simple variable to assign different cities.
A='Savannah'
A_venues = getNearbyVenues(names=neighborhoods['Neighborhood'],
latitudes=neighborhoods['Latitude'],
longitudes=neighborhoods['Longitude']
)
A_venues.head()
| Neighborhood | Neighborhood Latitude | Neighborhood Longitude | Venue | Venue Latitude | Venue Longitude | Venue Category | |
|---|---|---|---|---|---|---|---|
| 0 | Avalon | 32.05001 | -81.066843 | GameStop | 32.044100 | -81.068130 | Video Game Store |
| 1 | Avalon | 32.05001 | -81.066843 | Whole Foods Market | 32.043391 | -81.071361 | Grocery Store |
| 2 | Avalon | 32.05001 | -81.066843 | Hop Xing | 32.044566 | -81.067693 | Chinese Restaurant |
| 3 | Avalon | 32.05001 | -81.066843 | Firehouse Subs | 32.041880 | -81.066176 | Sandwich Place |
| 4 | Avalon | 32.05001 | -81.066843 | Sisters Of The New South | 32.042652 | -81.063602 | Restaurant |
A='Jacksonville'
A_venues = getNearbyVenues(names=neighborhoods['Neighborhood'],
latitudes=neighborhoods['Latitude'],
longitudes=neighborhoods['Longitude']
)
Arlington Avondale Belfort Station Brooklyn Church District Downtown East Jacksonville Empire Point Mandarin North Jacksonville Oakland Ortega River Park Riverside San Marco Sherwood Forest South Jacksonville South Side Springfield Stadium District Waterleaf West Jacksonville
A_venues.groupby('Neighborhood').count()
print('There are {} uniques categories.'.format(len(A_venues['Venue Category'].unique())))
There are 193 uniques categories.
A_venues.groupby('Neighborhood').count()
print('There are {} uniques categories.'.format(len(A_venues['Venue Category'].unique())))
There are 140 uniques categories.
One-hot Encoding for Generating Venue Frequency
# one hot encoding
A_onehot = pd.get_dummies(A_venues[['Venue Category']], prefix="", prefix_sep="")
# add neighborhood column back to dataframe
A_onehot['Neighborhood'] = A_venues['Neighborhood']
# move neighborhood column to the first column
fixed_columns = [A_onehot.columns[-1]] + list(A_onehot.columns[:-1])
A_onehot = A_onehot[fixed_columns]
A_onehot.head()
| Neighborhood | ATM | American Restaurant | Arcade | Art Gallery | Art Museum | Arts & Crafts Store | Asian Restaurant | Athletics & Sports | Auto Workshop | Automotive Shop | Bagel Shop | Bakery | Bank | Bar | Baseball Field | Baseball Stadium | Basketball Stadium | Beer Garden | Boat or Ferry | Breakfast Spot | Brewery | Bridal Shop | Burger Joint | Burrito Place | Business Service | Cafeteria | Café | Caribbean Restaurant | Chinese Restaurant | Cocktail Bar | Coffee Shop | Comfort Food Restaurant | Concert Hall | Construction & Landscaping | Convenience Store | Cosmetics Shop | Deli / Bodega | Dentist's Office | Dessert Shop | Diner | Disc Golf | Discount Store | Dive Bar | Doctor's Office | Dog Run | Donut Shop | Electronics Store | Exhibit | Fast Food Restaurant | Food Truck | French Restaurant | Fried Chicken Joint | Frozen Yogurt Shop | Gaming Cafe | Garden Center | Gas Station | Gay Bar | General Entertainment | Gift Shop | Golf Course | Grocery Store | Gym | Gym / Fitness Center | Harbor / Marina | Health & Beauty Service | Heliport | Historic Site | History Museum | Home Service | Hookah Bar | Hot Dog Joint | Hotel | Hotel Pool | IT Services | Ice Cream Shop | Indie Movie Theater | Intersection | Italian Restaurant | Japanese Restaurant | Jewelry Store | Juice Bar | Lawyer | Light Rail Station | Liquor Store | Lounge | Mediterranean Restaurant | Mexican Restaurant | Miscellaneous Shop | Movie Theater | Music Venue | New American Restaurant | Nightclub | Other Great Outdoors | Outdoors & Recreation | Park | Pet Store | Pharmacy | Photography Studio | Pizza Place | Playground | Plaza | Pool | Pub | Record Shop | Rental Car Location | Resort | Rest Area | Restaurant | Salon / Barbershop | Sandwich Place | Shipping Store | Shop & Service | Shopping Mall | Smoke Shop | Smoothie Shop | Soccer Field | Soccer Stadium | Spa | Speakeasy | Sporting Goods Shop | Sports Bar | Stadium | Steakhouse | Supplement Shop | Sushi Restaurant | Taco Place | Tanning Salon | Tea Room | Tennis Court | Tex-Mex Restaurant | Thai Restaurant | Theater | Thrift / Vintage Store | Trail | Train Station | Video Store | Vietnamese Restaurant | Volleyball Court | Wings Joint | Zoo | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Arlington | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 1 | Arlington | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 2 | Arlington | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 3 | Arlington | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 4 | Arlington | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 |
# one hot encoding
A_onehot = pd.get_dummies(A_venues[['Venue Category']], prefix="", prefix_sep="")
# add neighborhood column back to dataframe
A_onehot['Neighborhood'] = A_venues['Neighborhood']
# move neighborhood column to the first column
fixed_columns = [A_onehot.columns[-1]] + list(A_onehot.columns[:-1])
A_onehot = A_onehot[fixed_columns]
A_onehot.head()
| Yoga Studio | ATM | Accessories Store | American Restaurant | Antique Shop | Arcade | Art Gallery | Arts & Crafts Store | Asian Restaurant | Australian Restaurant | Auto Workshop | Automotive Shop | BBQ Joint | Bagel Shop | Bakery | Bank | Bar | Baseball Field | Baseball Stadium | Bed & Breakfast | Beer Store | Big Box Store | Bike Rental / Bike Share | Bistro | Boat or Ferry | Bookstore | Boutique | Bowling Alley | Breakfast Spot | Brewery | Bubble Tea Shop | Building | Burger Joint | Burrito Place | Bus Station | Business Service | Café | Campground | Candy Store | Caribbean Restaurant | Chinese Restaurant | Clothing Store | Cocktail Bar | Coffee Shop | College Arts Building | Construction & Landscaping | Convenience Store | Cosmetics Shop | Cuban Restaurant | Cupcake Shop | Dance Studio | Deli / Bodega | Department Store | Dessert Shop | Diner | Discount Store | Dive Bar | Dog Run | Donut Shop | Drive-in Theater | Electronics Store | Farm | Farmers Market | Fast Food Restaurant | Food | Food & Drink Shop | Food Truck | Fountain | French Restaurant | Fried Chicken Joint | Frozen Yogurt Shop | Furniture / Home Store | Gaming Cafe | Garden | Gas Station | General Entertainment | General Travel | Gift Shop | Golf Course | Gourmet Shop | Greek Restaurant | Grocery Store | Gun Range | Gym | Gym / Fitness Center | Gymnastics Gym | Harbor / Marina | Hardware Store | Health & Beauty Service | Historic Site | History Museum | Hobby Shop | Home Service | Hospital | Hotel | Hotel Bar | Hotpot Restaurant | IT Services | Ice Cream Shop | Indian Restaurant | Intersection | Italian Restaurant | Japanese Restaurant | Jewelry Store | Kids Store | Kitchen Supply Store | Korean Restaurant | Lake | Latin American Restaurant | Laundry Service | Lawyer | Lingerie Store | Liquor Store | Locksmith | Lounge | Market | Martial Arts Dojo | Massage Studio | Medical Center | Mediterranean Restaurant | Men's Store | Metro Station | Mexican Restaurant | Middle Eastern Restaurant | Mobile Phone Shop | Moving Target | Multiplex | Museum | Neighborhood | New American Restaurant | Nightclub | Noodle House | Optical Shop | Outdoors & Recreation | Outlet Mall | Paper / Office Supplies Store | Park | Persian Restaurant | Pet Store | Pharmacy | Photography Studio | Pie Shop | Pizza Place | Playground | Plaza | Pool | Pub | Record Shop | Rental Car Location | Restaurant | River | Road | Salon / Barbershop | Sandwich Place | Scenic Lookout | Seafood Restaurant | Shipping Store | Shoe Store | Shopping Mall | Shopping Plaza | Skating Rink | Smoothie Shop | Soccer Field | Soccer Stadium | Southern / Soul Food Restaurant | Spa | Sporting Goods Shop | Sports Bar | Storage Facility | Supermarket | Supplement Shop | Sushi Restaurant | Taco Place | Tailor Shop | Tanning Salon | Tea Room | Tennis Court | Thai Restaurant | Theater | Thrift / Vintage Store | Tour Provider | Tourist Information Center | Track | Vegetarian / Vegan Restaurant | Video Game Store | Video Store | Vietnamese Restaurant | Vineyard | Whisky Bar | Wine Bar | Winery | Wings Joint | Women's Store | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Avalon | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Avalon | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Avalon | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Avalon | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Avalon | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
#Savannah
A_grouped = A_onehot.groupby('Neighborhood').mean().reset_index()
A_grouped.head()
| Neighborhood | Yoga Studio | ATM | Accessories Store | American Restaurant | Antique Shop | Arcade | Art Gallery | Arts & Crafts Store | Asian Restaurant | Australian Restaurant | Auto Workshop | Automotive Shop | BBQ Joint | Bagel Shop | Bakery | Bank | Bar | Baseball Field | Baseball Stadium | Bed & Breakfast | Beer Store | Big Box Store | Bike Rental / Bike Share | Bistro | Boat or Ferry | Bookstore | Boutique | Bowling Alley | Breakfast Spot | Brewery | Bubble Tea Shop | Building | Burger Joint | Burrito Place | Bus Station | Business Service | Café | Campground | Candy Store | Caribbean Restaurant | Chinese Restaurant | Clothing Store | Cocktail Bar | Coffee Shop | College Arts Building | Construction & Landscaping | Convenience Store | Cosmetics Shop | Cuban Restaurant | Cupcake Shop | Dance Studio | Deli / Bodega | Department Store | Dessert Shop | Diner | Discount Store | Dive Bar | Dog Run | Donut Shop | Drive-in Theater | Electronics Store | Farm | Farmers Market | Fast Food Restaurant | Food | Food & Drink Shop | Food Truck | Fountain | French Restaurant | Fried Chicken Joint | Frozen Yogurt Shop | Furniture / Home Store | Gaming Cafe | Garden | Gas Station | General Entertainment | General Travel | Gift Shop | Golf Course | Gourmet Shop | Greek Restaurant | Grocery Store | Gun Range | Gym | Gym / Fitness Center | Gymnastics Gym | Harbor / Marina | Hardware Store | Health & Beauty Service | Historic Site | History Museum | Hobby Shop | Home Service | Hospital | Hotel | Hotel Bar | Hotpot Restaurant | IT Services | Ice Cream Shop | Indian Restaurant | Intersection | Italian Restaurant | Japanese Restaurant | Jewelry Store | Kids Store | Kitchen Supply Store | Korean Restaurant | Lake | Latin American Restaurant | Laundry Service | Lawyer | Lingerie Store | Liquor Store | Locksmith | Lounge | Market | Martial Arts Dojo | Massage Studio | Medical Center | Mediterranean Restaurant | Men's Store | Metro Station | Mexican Restaurant | Middle Eastern Restaurant | Mobile Phone Shop | Moving Target | Multiplex | Museum | New American Restaurant | Nightclub | Noodle House | Optical Shop | Outdoors & Recreation | Outlet Mall | Paper / Office Supplies Store | Park | Persian Restaurant | Pet Store | Pharmacy | Photography Studio | Pie Shop | Pizza Place | Playground | Plaza | Pool | Pub | Record Shop | Rental Car Location | Restaurant | River | Road | Salon / Barbershop | Sandwich Place | Scenic Lookout | Seafood Restaurant | Shipping Store | Shoe Store | Shopping Mall | Shopping Plaza | Skating Rink | Smoothie Shop | Soccer Field | Soccer Stadium | Southern / Soul Food Restaurant | Spa | Sporting Goods Shop | Sports Bar | Storage Facility | Supermarket | Supplement Shop | Sushi Restaurant | Taco Place | Tailor Shop | Tanning Salon | Tea Room | Tennis Court | Thai Restaurant | Theater | Thrift / Vintage Store | Tour Provider | Tourist Information Center | Track | Vegetarian / Vegan Restaurant | Video Game Store | Video Store | Vietnamese Restaurant | Vineyard | Whisky Bar | Wine Bar | Winery | Wings Joint | Women's Store | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Avalon | 0.0 | 0.0 | 0.0 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.033333 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.033333 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.033333 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.066667 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.00 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.033333 | 0.0 | 0.0 | 0.0 | 0.033333 | 0.0 | 0.0 | 0.0 | 0.00 | 0.0 | 0.0 | 0.0 | 0.033333 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.033333 | 0.0 | 0.0 | 0.0 | 0.00 | 0.0 | 0.0 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.033333 | 0.033333 | 0.0 | 0.0 | 0.033333 | 0.0 | 0.0 | 0.033333 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.033333 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.033333 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.00 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.066667 | 0.000000 | 0.066667 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.033333 | 0.0 | 0.033333 | 0.033333 | 0.0 | 0.0 | 0.066667 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.0 | 0.033333 | 0.033333 | 0.0 | 0.0 | 0.000000 | 0.066667 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.033333 | 0.033333 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 1 | Avondale | 0.0 | 0.0 | 0.0 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.00 | 0.071429 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.00 | 0.0 | 0.0 | 0.0 | 0.071429 | 0.142857 | 0.0 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.00 | 0.0 | 0.0 | 0.071429 | 0.000000 | 0.0 | 0.0 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.071429 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.071429 | 0.0 | 0.0 | 0.0 | 0.00 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.071429 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.142857 | 0.0 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.0 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.000000 | 0.000000 | 0.0 | 0.071429 | 0.0 | 0.0 | 0.0 | 0.0 | 0.071429 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.071429 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.071429 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 2 | Baldwin Park | 0.0 | 0.0 | 0.0 | 0.066667 | 0.033333 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.033333 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.033333 | 0.0 | 0.00 | 0.000000 | 0.033333 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.00 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.00 | 0.1 | 0.0 | 0.000000 | 0.033333 | 0.0 | 0.0 | 0.033333 | 0.000000 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.066667 | 0.0 | 0.0 | 0.0 | 0.00 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.033333 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.033333 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.100000 | 0.0 | 0.033333 | 0.000000 | 0.0 | 0.0 | 0.000000 | 0.066667 | 0.033333 | 0.033333 | 0.033333 | 0.0 | 0.000000 | 0.033333 | 0.0 | 0.0 | 0.033333 | 0.000000 | 0.0 | 0.033333 | 0.0 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.066667 | 0.0 | 0.033333 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 3 | Bartow | 0.0 | 0.0 | 0.0 | 0.100000 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.100000 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.00 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.200000 | 0.0 | 0.0 | 0.0 | 0.00 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.00 | 0.0 | 0.0 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.000000 | 0.100000 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.00 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.100000 | 0.0 | 0.200000 | 0.000000 | 0.0 | 0.0 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.0 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.000000 | 0.000000 | 0.0 | 0.100000 | 0.1 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 4 | Bayview | 0.0 | 0.0 | 0.0 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.25 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.25 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.25 | 0.0 | 0.0 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.25 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.0 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.000000 | 0.000000 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
#Jacksonville
A_grouped = A_onehot.groupby('Neighborhood').mean().reset_index()
A_grouped.head()
| Neighborhood | ATM | American Restaurant | Arcade | Art Gallery | Art Museum | Arts & Crafts Store | Asian Restaurant | Athletics & Sports | Auto Workshop | Automotive Shop | Bagel Shop | Bakery | Bank | Bar | Baseball Field | Baseball Stadium | Basketball Stadium | Beer Garden | Boat or Ferry | Breakfast Spot | Brewery | Bridal Shop | Burger Joint | Burrito Place | Business Service | Cafeteria | Café | Caribbean Restaurant | Chinese Restaurant | Cocktail Bar | Coffee Shop | Comfort Food Restaurant | Concert Hall | Construction & Landscaping | Convenience Store | Cosmetics Shop | Deli / Bodega | Dentist's Office | Dessert Shop | Diner | Disc Golf | Discount Store | Dive Bar | Doctor's Office | Dog Run | Donut Shop | Electronics Store | Exhibit | Fast Food Restaurant | Food Truck | French Restaurant | Fried Chicken Joint | Frozen Yogurt Shop | Gaming Cafe | Garden Center | Gas Station | Gay Bar | General Entertainment | Gift Shop | Golf Course | Grocery Store | Gym | Gym / Fitness Center | Harbor / Marina | Health & Beauty Service | Heliport | Historic Site | History Museum | Home Service | Hookah Bar | Hot Dog Joint | Hotel | Hotel Pool | IT Services | Ice Cream Shop | Indie Movie Theater | Intersection | Italian Restaurant | Japanese Restaurant | Jewelry Store | Juice Bar | Lawyer | Light Rail Station | Liquor Store | Lounge | Mediterranean Restaurant | Mexican Restaurant | Miscellaneous Shop | Movie Theater | Music Venue | New American Restaurant | Nightclub | Other Great Outdoors | Outdoors & Recreation | Park | Pet Store | Pharmacy | Photography Studio | Pizza Place | Playground | Plaza | Pool | Pub | Record Shop | Rental Car Location | Resort | Rest Area | Restaurant | Salon / Barbershop | Sandwich Place | Shipping Store | Shop & Service | Shopping Mall | Smoke Shop | Smoothie Shop | Soccer Field | Soccer Stadium | Spa | Speakeasy | Sporting Goods Shop | Sports Bar | Stadium | Steakhouse | Supplement Shop | Sushi Restaurant | Taco Place | Tanning Salon | Tea Room | Tennis Court | Tex-Mex Restaurant | Thai Restaurant | Theater | Thrift / Vintage Store | Trail | Train Station | Video Store | Vietnamese Restaurant | Volleyball Court | Wings Joint | Zoo | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Arlington | 0.043478 | 0.043478 | 0.000000 | 0.0 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.043478 | 0.0 | 0.000000 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.043478 | 0.000000 | 0.000000 | 0.00 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.043478 | 0.000000 | 0.0 | 0.000000 | 0.000000 | 0.043478 | 0.0 | 0.000000 | 0.00 | 0.000000 | 0.0 | 0.0 | 0.043478 | 0.0 | 0.000000 | 0.0 | 0.043478 | 0.0 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.043478 | 0.0 | 0.000000 | 0.000000 | 0.043478 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.000000 | 0.000000 | 0.043478 | 0.000000 | 0.000000 | 0.000000 | 0.0 | 0.000000 | 0.043478 | 0.0 | 0.000000 | 0.000000 | 0.043478 | 0.00 | 0.0 | 0.000000 | 0.043478 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.00 | 0.0 | 0.000000 | 0.043478 | 0.0 | 0.0 | 0.043478 | 0.000000 | 0.043478 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.00 | 0.0 | 0.000000 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.043478 | 0.00 | 0.043478 | 0.00 | 0.00 | 0.043478 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.00 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.00 | 0.0 | 0.043478 | 0.0 | 0.0 | 0.086957 | 0.00 | 0.0 | 0.000000 | 0.0 |
| 1 | Avondale | 0.000000 | 0.000000 | 0.000000 | 0.0 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.041667 | 0.000000 | 0.041667 | 0.0 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.041667 | 0.041667 | 0.00 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.041667 | 0.000000 | 0.041667 | 0.0 | 0.000000 | 0.000000 | 0.041667 | 0.0 | 0.041667 | 0.00 | 0.000000 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.000000 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.041667 | 0.000000 | 0.0 | 0.041667 | 0.041667 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.041667 | 0.0 | 0.041667 | 0.000000 | 0.0 | 0.000000 | 0.000000 | 0.000000 | 0.00 | 0.0 | 0.000000 | 0.000000 | 0.000000 | 0.041667 | 0.0 | 0.0 | 0.0 | 0.00 | 0.0 | 0.000000 | 0.041667 | 0.0 | 0.0 | 0.000000 | 0.041667 | 0.000000 | 0.0 | 0.0 | 0.041667 | 0.0 | 0.00 | 0.0 | 0.083333 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.041667 | 0.00 | 0.000000 | 0.00 | 0.00 | 0.000000 | 0.083333 | 0.000000 | 0.0 | 0.0 | 0.00 | 0.0 | 0.0 | 0.041667 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.00 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.000000 | 0.00 | 0.0 | 0.041667 | 0.0 |
| 2 | Belfort Station | 0.000000 | 0.000000 | 0.055556 | 0.0 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.000000 | 0.055556 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.000000 | 0.000000 | 0.00 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.055556 | 0.055556 | 0.000000 | 0.0 | 0.000000 | 0.000000 | 0.000000 | 0.0 | 0.000000 | 0.00 | 0.000000 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.055556 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.000000 | 0.0 | 0.000000 | 0.000000 | 0.055556 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.055556 | 0.055556 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.0 | 0.000000 | 0.000000 | 0.0 | 0.111111 | 0.055556 | 0.111111 | 0.00 | 0.0 | 0.000000 | 0.055556 | 0.055556 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.00 | 0.0 | 0.000000 | 0.055556 | 0.0 | 0.0 | 0.000000 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.00 | 0.0 | 0.000000 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.00 | 0.111111 | 0.00 | 0.00 | 0.000000 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.00 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.00 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.000000 | 0.00 | 0.0 | 0.000000 | 0.0 |
| 3 | Brooklyn | 0.000000 | 0.000000 | 0.000000 | 0.0 | 0.033333 | 0.033333 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.000000 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.000000 | 0.000000 | 0.00 | 0.033333 | 0.033333 | 0.0 | 0.0 | 0.1 | 0.0 | 0.000000 | 0.000000 | 0.000000 | 0.0 | 0.033333 | 0.033333 | 0.000000 | 0.0 | 0.066667 | 0.00 | 0.033333 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.033333 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.000000 | 0.0 | 0.000000 | 0.000000 | 0.000000 | 0.033333 | 0.0 | 0.0 | 0.0 | 0.033333 | 0.033333 | 0.033333 | 0.000000 | 0.033333 | 0.033333 | 0.033333 | 0.0 | 0.000000 | 0.000000 | 0.0 | 0.000000 | 0.000000 | 0.000000 | 0.00 | 0.0 | 0.033333 | 0.000000 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.00 | 0.0 | 0.033333 | 0.033333 | 0.0 | 0.0 | 0.000000 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.066667 | 0.0 | 0.00 | 0.0 | 0.000000 | 0.033333 | 0.033333 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.00 | 0.033333 | 0.00 | 0.00 | 0.000000 | 0.000000 | 0.033333 | 0.0 | 0.0 | 0.00 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.00 | 0.0 | 0.033333 | 0.0 | 0.0 | 0.000000 | 0.00 | 0.0 | 0.000000 | 0.0 |
| 4 | Church District | 0.000000 | 0.000000 | 0.000000 | 0.0 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.040000 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.000000 | 0.000000 | 0.04 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.040000 | 0.000000 | 0.000000 | 0.0 | 0.000000 | 0.000000 | 0.000000 | 0.0 | 0.000000 | 0.04 | 0.000000 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.000000 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.000000 | 0.000000 | 0.0 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.080000 | 0.040000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.0 | 0.000000 | 0.000000 | 0.0 | 0.000000 | 0.000000 | 0.000000 | 0.04 | 0.0 | 0.040000 | 0.000000 | 0.080000 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.04 | 0.0 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.000000 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.04 | 0.0 | 0.080000 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.040000 | 0.08 | 0.040000 | 0.04 | 0.04 | 0.040000 | 0.000000 | 0.000000 | 0.0 | 0.0 | 0.04 | 0.0 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.04 | 0.0 | 0.000000 | 0.0 | 0.0 | 0.000000 | 0.04 | 0.0 | 0.000000 | 0.0 |
num_top_venues = 10
for hood in A_grouped['Neighborhood']:
print("----"+hood+"----")
temp = A_grouped[A_grouped['Neighborhood'] == hood].T.reset_index()
temp.columns = ['venue','freq']
temp = temp.iloc[1:]
temp['freq'] = temp['freq'].astype(float)
temp = temp.round({'freq': 2})
print(temp.sort_values('freq', ascending=False).reset_index(drop=True).head(num_top_venues))
print('\n')
In East Savannah, pizza places(18%) and discount stores(18%) account for 36% of venues. In Southover, Savannah bakeries(25%), breweries(25%), and discount stores(25%) account for 75% of venues.
For output go to Savannah_Venue
num_top_venues = 10
for hood in A_grouped['Neighborhood']:
print("----"+hood+"----")
temp = A_grouped[A_grouped['Neighborhood'] == hood].T.reset_index()
temp.columns = ['venue','freq']
temp = temp.iloc[1:]
temp['freq'] = temp['freq'].astype(float)
temp = temp.round({'freq': 2})
print(temp.sort_values('freq', ascending=False).reset_index(drop=True).head(num_top_venues))
print('\n')
In North Jacksonville and East Jacksonville, fast food restaurants account for about 38% of venues. In East Savannah, pizza places(18%) and discount stores(18%) account for 36% of venues. In Southover, Savannah bakeries(25%), breweries(25%), and discount stores(25%) account for 75% of venues.
For output go to Jacksonville_Venue
Get most common revenues and place in dataframe.
def return_most_common_venues(row, num_top_venues):
row_categories = row.iloc[1:]
row_categories_sorted = row_categories.sort_values(ascending=False)
return row_categories_sorted.index.values[0:num_top_venues]
Savannah Top 10 Revenues
num_top_venues = 10
indicators = ['st', 'nd', 'rd']
# create columns according to number of top venues
columns = ['Neighborhood']
for ind in np.arange(num_top_venues):
try:
columns.append('{}{} Most Common Venue'.format(ind+1, indicators[ind]))
except:
columns.append('{}th Most Common Venue'.format(ind+1))
# create a new dataframe
A_neighborhoods_venues_sorted = pd.DataFrame(columns=columns)
A_neighborhoods_venues_sorted['Neighborhood'] = A_grouped['Neighborhood']
for ind in np.arange(A_grouped.shape[0]):
A_neighborhoods_venues_sorted.iloc[ind, 1:] = return_most_common_venues(A_grouped.iloc[ind, :], num_top_venues)
A_neighborhoods_venues_sorted.head(10)
| Neighborhood | 1st Most Common Venue | 2nd Most Common Venue | 3rd Most Common Venue | 4th Most Common Venue | 5th Most Common Venue | 6th Most Common Venue | 7th Most Common Venue | 8th Most Common Venue | 9th Most Common Venue | 10th Most Common Venue | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Avalon | Mobile Phone Shop | Pizza Place | Chinese Restaurant | Mexican Restaurant | Sandwich Place | Hardware Store | Fried Chicken Joint | Breakfast Spot | Fast Food Restaurant | Rental Car Location |
| 1 | Avondale | Park | Food | Sporting Goods Shop | Tour Provider | Seafood Restaurant | Fast Food Restaurant | Skating Rink | Liquor Store | General Travel | Convenience Store |
| 2 | Baldwin Park | Gas Station | Park | Intersection | Playground | Southern / Soul Food Restaurant | American Restaurant | Seafood Restaurant | Restaurant | Salon / Barbershop | Sporting Goods Shop |
| 3 | Bartow | Pet Store | Discount Store | Grocery Store | Seafood Restaurant | American Restaurant | Park | Chinese Restaurant | Shipping Store | Food & Drink Shop | Food |
| 4 | Bayview | Construction & Landscaping | Garden | Kids Store | Drive-in Theater | Women's Store | Electronics Store | French Restaurant | Fountain | Food Truck | Food & Drink Shop |
| 5 | Beach Institute | Plaza | Park | Bed & Breakfast | Hotel Bar | Tea Room | Hotel | Italian Restaurant | Fountain | Farmers Market | Dive Bar |
| 6 | Berkshire Woods | Park | Home Service | Photography Studio | Coffee Shop | Women's Store | Drive-in Theater | Fountain | Food Truck | Food & Drink Shop | Food |
| 7 | Bingville | Convenience Store | Park | Discount Store | Mexican Restaurant | Electronics Store | Bar | Fast Food Restaurant | Bistro | Chinese Restaurant | Grocery Store |
| 8 | Blueberry Hill | Farm | Women's Store | Wings Joint | Fried Chicken Joint | French Restaurant | Fountain | Food Truck | Food & Drink Shop | Food | Fast Food Restaurant |
| 9 | Brookview | Chinese Restaurant | Intersection | Construction & Landscaping | Furniture / Home Store | Food & Drink Shop | Food | Golf Course | Thrift / Vintage Store | Southern / Soul Food Restaurant | Farm |
Jacksonville Top 10 Revenues
#Jacksonville
num_top_venues = 10
indicators = ['st', 'nd', 'rd']
# create columns according to number of top venues
columns = ['Neighborhood']
for ind in np.arange(num_top_venues):
try:
columns.append('{}{} Most Common Venue'.format(ind+1, indicators[ind]))
except:
columns.append('{}th Most Common Venue'.format(ind+1))
# create a new dataframe
A_neighborhoods_venues_sorted = pd.DataFrame(columns=columns)
A_neighborhoods_venues_sorted['Neighborhood'] = A_grouped['Neighborhood']
for ind in np.arange(A_grouped.shape[0]):
A_neighborhoods_venues_sorted.iloc[ind, 1:] = return_most_common_venues(A_grouped.iloc[ind, :], num_top_venues)
A_neighborhoods_venues_sorted.head(10)
| Neighborhood | 1st Most Common Venue | 2nd Most Common Venue | 3rd Most Common Venue | 4th Most Common Venue | 5th Most Common Venue | 6th Most Common Venue | 7th Most Common Venue | 8th Most Common Venue | 9th Most Common Venue | 10th Most Common Venue | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Arlington | Video Store | Restaurant | ATM | Italian Restaurant | Mexican Restaurant | Shopping Mall | Seafood Restaurant | Sandwich Place | Fried Chicken Joint | Bookstore |
| 1 | Avondale | Park | Pizza Place | Convenience Store | Gaming Cafe | Plaza | Deli / Bodega | New American Restaurant | Coffee Shop | Chinese Restaurant | Smoke Shop |
| 2 | Belfort Station | Hotel | Sandwich Place | Automotive Shop | Cocktail Bar | Chinese Restaurant | Food Truck | Gas Station | Japanese Restaurant | Italian Restaurant | Mexican Restaurant |
| 3 | Brooklyn | Café | Park | Deli / Bodega | Gym / Fitness Center | Gym | Smoothie Shop | Sandwich Place | Concert Hall | Plaza | Playground |
| 4 | Church District | Grocery Store | Pizza Place | Japanese Restaurant | Intersection | Spa | Shopping Mall | Pharmacy | Liquor Store | Shipping Store | Sandwich Place |
| 5 | Downtown | Bakery | History Museum | Truck Stop | Gas Station | Bar | Italian Restaurant | Greek Restaurant | Rest Area | American Restaurant | Dive Bar |
| 6 | East Jacksonville | Fast Food Restaurant | Video Store | Light Rail Station | Train Station | Sandwich Place | Bakery | Zoo | Event Service | Flea Market | Farmers Market |
| 7 | Empire Point | Chiropractor | Lawyer | American Restaurant | Rental Car Location | Gas Station | Baseball Field | Donut Shop | Flea Market | Fast Food Restaurant | Farmers Market |
| 8 | Mandarin | Event Service | Pet Store | Business Service | Farmers Market | Park | Food Truck | Flea Market | Fast Food Restaurant | Exhibit | Zoo |
| 9 | North Jacksonville | Fast Food Restaurant | Video Store | Light Rail Station | Train Station | Sandwich Place | Bakery | Zoo | Event Service | Flea Market | Farmers Market |
Read CSV Files with Table Information
pip install xlrd
Collecting xlrd
Downloading xlrd-1.2.0-py2.py3-none-any.whl (103 kB)
|████████████████████████████████| 103 kB 3.6 MB/s eta 0:00:01
Installing collected packages: xlrd
Successfully installed xlrd-1.2.0
Note: you may need to restart the kernel to use updated packages.
pwd
'/home/jovyan/demo'
import pandas as pd
County_Table= pd.read_csv('/home/jovyan/demo/County_Health_Rankings.csv')
Import County Health Rankings Table
Reference:https://www.countyhealthrankings.org/app/georgia/2020/compare/snapshot?counties=12_031%2013_051
County_Table[County_Table.isnull()]=""
County_Table.head()
| Unnamed: 0 | Duval (DU) , FL | Chatham (CA) , GA | |
|---|---|---|---|
| 0 | Demographics | ||
| 1 | Population | 950,181 | 289,195 |
| 2 | % below 18 years of age | 22.60% | 21.20% |
| 3 | % 65 and older | 14.00% | 15.40% |
| 4 | % Non-Hispanic Black | 29.50% | 40.10% |
Import Death by Age Table
Reference:https://www.worldometers.info/coronavirus/coronavirus-age-sex-demographics/
As of May 13th
Death_by_Age_Table= pd.read_csv('/home/jovyan/demo/Death_By_Age_Coronavirus.csv')
Import Fatalaties and Hospital Capacities
Reference:https://bao.arcgis.com/covid-19/jhu/county/13051.html
Capacity_Table= pd.read_csv('/home/jovyan/demo/Hospital_Capacity.csv')
Table 1. Savannah Venues
Savannah_data=A_neighborhoods_venues_sorted
Savannah_data
| Neighborhood | 1st Most Common Venue | 2nd Most Common Venue | 3rd Most Common Venue | 4th Most Common Venue | 5th Most Common Venue | 6th Most Common Venue | 7th Most Common Venue | 8th Most Common Venue | 9th Most Common Venue | 10th Most Common Venue | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Avalon | Mobile Phone Shop | Pizza Place | Chinese Restaurant | Sandwich Place | Mexican Restaurant | Restaurant | Big Box Store | Breakfast Spot | Fast Food Restaurant | Hardware Store |
| 1 | Avondale | Park | Sporting Goods Shop | General Travel | Convenience Store | Historic Site | Seafood Restaurant | Skating Rink | Fast Food Restaurant | Food | Liquor Store |
| 2 | Baldwin Park | Gas Station | Park | Intersection | Playground | American Restaurant | Southern / Soul Food Restaurant | Salon / Barbershop | Sporting Goods Shop | Liquor Store | Lounge |
| 3 | Bartow | Pet Store | Park | Discount Store | Food | Business Service | Seafood Restaurant | Chinese Restaurant | Grocery Store | Mobile Phone Shop | American Restaurant |
| 4 | Bayview | Garden | Kids Store | Drive-in Theater | Women's Store | Donut Shop | Food & Drink Shop | Food | Flower Shop | Fish Market | Fast Food Restaurant |
| 5 | Beach Institute | Plaza | Bed & Breakfast | Park | Southern / Soul Food Restaurant | Hotel | Italian Restaurant | Dive Bar | Bakery | Tea Room | BBQ Joint |
| 6 | Berkshire Woods | Park | Home Service | Photography Studio | Coffee Shop | Donut Shop | Food | Flower Shop | Fish Market | Fast Food Restaurant | Farmers Market |
| 7 | Bingville | Convenience Store | Park | Discount Store | Wings Joint | Grocery Store | General Entertainment | Fast Food Restaurant | Mexican Restaurant | Electronics Store | Bar |
| 8 | Blueberry Hill | Farm | Women's Store | Wings Joint | Food Truck | Food & Drink Shop | Food | Flower Shop | Fish Market | Fast Food Restaurant | Farmers Market |
| 9 | Brookview | Chinese Restaurant | Intersection | Construction & Landscaping | Food | Furniture / Home Store | Golf Course | Food & Drink Shop | Thrift / Vintage Store | Southern / Soul Food Restaurant | Electronics Store |
| 10 | Cann Park | Bakery | Chinese Restaurant | Seafood Restaurant | Mobile Phone Shop | Discount Store | Intersection | Park | Massage Studio | Salon / Barbershop | Gym / Fitness Center |
| 11 | Carver Heights | Coffee Shop | American Restaurant | Seafood Restaurant | Park | Café | Restaurant | Pub | Spa | Brewery | Burger Joint |
| 12 | Chatham Crescent | Café | Seafood Restaurant | American Restaurant | Antique Shop | Coffee Shop | Southern / Soul Food Restaurant | Gas Station | Playground | Plaza | Spa |
| 13 | Chatham Parkway | Sandwich Place | Pharmacy | Breakfast Spot | Fast Food Restaurant | Gym | Gun Range | Italian Restaurant | Japanese Restaurant | Women's Store | Flower Shop |
| 14 | Chippewa | Cosmetics Shop | Lingerie Store | Department Store | Furniture / Home Store | Mexican Restaurant | Smoothie Shop | Restaurant | Coffee Shop | Deli / Bodega | Mobile Phone Shop |
| 15 | Cloverdale | Park | Moving Target | Road | Intersection | Women's Store | Donut Shop | Food | Flower Shop | Fish Market | Fast Food Restaurant |
| 16 | Coffee Bluff | Photography Studio | Harbor / Marina | Women's Store | Dog Run | Food | Flower Shop | Fish Market | Fast Food Restaurant | Farmers Market | Farm |
| 17 | Colonial Oaks | Home Service | Photography Studio | Coffee Shop | Park | Donut Shop | Food | Flower Shop | Fish Market | Fast Food Restaurant | Farmers Market |
| 18 | Colonial Village | Home Service | Photography Studio | Coffee Shop | Park | Donut Shop | Food | Flower Shop | Fish Market | Fast Food Restaurant | Farmers Market |
| 19 | Dawes Avenue | Discount Store | Sandwich Place | Bakery | Construction & Landscaping | Deli / Bodega | Brewery | Grocery Store | Food | Flower Shop | Fish Market |
| 20 | Dixon Park | Coffee Shop | American Restaurant | BBQ Joint | Restaurant | Park | Historic Site | Farmers Market | Middle Eastern Restaurant | New American Restaurant | Italian Restaurant |
| 21 | Downtown Savannah | Plaza | Bistro | Southern / Soul Food Restaurant | History Museum | Australian Restaurant | Museum | Pub | Lounge | French Restaurant | Bookstore |
| 22 | East Savannah | Pizza Place | Discount Store | Grocery Store | Ice Cream Shop | Supermarket | Sandwich Place | BBQ Joint | Construction & Landscaping | Department Store | Drive-in Theater |
| 23 | Eastside | Park | Coffee Shop | Sandwich Place | Chinese Restaurant | Pizza Place | Home Service | Ice Cream Shop | Big Box Store | Fried Chicken Joint | Discount Store |
| 24 | Edgemere | Park | Baseball Field | Pharmacy | Convenience Store | Pool | Tennis Court | Salon / Barbershop | Dog Run | Coffee Shop | Plaza |
| 25 | Fairfield | Pharmacy | Sandwich Place | Convenience Store | Café | Gas Station | Pizza Place | Fast Food Restaurant | Dessert Shop | Supplement Shop | Tanning Salon |
| 26 | Fairway Oaks | Pharmacy | Fast Food Restaurant | Hospital | Intersection | Pizza Place | Dessert Shop | Caribbean Restaurant | Café | Burrito Place | Sandwich Place |
| 27 | Fernwood | Discount Store | Sports Bar | Convenience Store | American Restaurant | Donut Shop | Fast Food Restaurant | Market | Shopping Mall | Seafood Restaurant | Sandwich Place |
| 28 | Forest Park | Candy Store | Southern / Soul Food Restaurant | Lounge | Gourmet Shop | Hotel | Plaza | Park | New American Restaurant | Seafood Restaurant | Boutique |
| 29 | Forest Ridge | Candy Store | Southern / Soul Food Restaurant | Lounge | Gourmet Shop | Hotel | Plaza | Park | New American Restaurant | Seafood Restaurant | Boutique |
| 30 | Habersham Woods | Hotel | Coffee Shop | Grocery Store | Women's Store | Sandwich Place | Market | Shopping Plaza | Burger Joint | Seafood Restaurant | Men's Store |
| 31 | Highland Park | Asian Restaurant | Sandwich Place | American Restaurant | Multiplex | Sushi Restaurant | Ice Cream Shop | Pizza Place | Massage Studio | Southern / Soul Food Restaurant | Spa |
| 32 | Hillcrest | Discount Store | Gym | Costume Shop | Indian Restaurant | Seafood Restaurant | Fried Chicken Joint | Sports Bar | Supermarket | BBQ Joint | Intersection |
| 33 | Hitch Village | Plaza | Coffee Shop | Bookstore | Bistro | Tea Room | Diner | Cocktail Bar | Museum | Dive Bar | Pub |
| 34 | Jackson Park | BBQ Joint | River | Women's Store | Food & Drink Shop | Food | Flower Shop | Fish Market | Fast Food Restaurant | Farmers Market | Farm |
| 35 | Kayton | Plaza | Coffee Shop | Museum | Fried Chicken Joint | Bed & Breakfast | Bar | Bakery | Playground | Pub | Farmers Market |
| 36 | Kensington Park | Hotel | Café | Pharmacy | Grocery Store | Southern / Soul Food Restaurant | Market | Breakfast Spot | Seafood Restaurant | Sandwich Place | Salon / Barbershop |
| 37 | Laurel Grove | Park | Fried Chicken Joint | Bakery | Mobile Phone Shop | Intersection | Seafood Restaurant | Women's Store | Drive-in Theater | Flower Shop | Fish Market |
| 38 | Live Oak | Convenience Store | Shipping Store | Cosmetics Shop | Food & Drink Shop | Food | Flower Shop | Fish Market | Fast Food Restaurant | Farmers Market | Farm |
| 39 | Mayfair | Bakery | Lake | Kids Store | Bar | Park | Baseball Field | Bike Rental / Bike Share | Pool | Thrift / Vintage Store | Track |
| 40 | Medical Arts | Sandwich Place | Pharmacy | Pizza Place | Café | Coffee Shop | Hospital | Food & Drink Shop | Smoothie Shop | Shopping Plaza | Medical Center |
| 41 | Metropolitan | Bus Station | Nightclub | Food | Playground | Soccer Field | Seafood Restaurant | Food Truck | Soccer Stadium | Metro Station | Sandwich Place |
| 42 | Oakdale | Pharmacy | Cosmetics Shop | Video Store | Gas Station | Deli / Bodega | Pizza Place | Dessert Shop | Multiplex | Mexican Restaurant | Salon / Barbershop |
| 43 | Oakhurst | Sandwich Place | Discount Store | Bakery | Shopping Mall | Liquor Store | Smoothie Shop | Lingerie Store | Electronics Store | Korean Restaurant | Rental Car Location |
| 44 | Oakland Park | Discount Store | American Restaurant | Clothing Store | Coffee Shop | Seafood Restaurant | Sandwich Place | Liquor Store | Sports Bar | Rental Car Location | Big Box Store |
| 45 | Oglethorpe | Plaza | Bistro | Southern / Soul Food Restaurant | Dessert Shop | Coffee Shop | Museum | Bar | Cosmetics Shop | New American Restaurant | Pub |
| 46 | Paradise Park | Korean Restaurant | Historic Site | Bakery | Park | Chinese Restaurant | Fast Food Restaurant | Cosmetics Shop | Café | Pet Service | ATM |
| 47 | Parkside | Golf Course | Brewery | Business Service | Gas Station | Liquor Store | Locksmith | Chinese Restaurant | Sandwich Place | Grocery Store | IT Services |
| 48 | Pine Gardens | Convenience Store | Clothing Store | Building | Furniture / Home Store | Liquor Store | Seafood Restaurant | Bar | Discount Store | Golf Course | Park |
| 49 | Poplar Place | Baseball Field | Scenic Lookout | Donut Shop | Food & Drink Shop | Food | Flower Shop | Fish Market | Fast Food Restaurant | Farmers Market | Farm |
| 50 | Ridgewood | American Restaurant | Café | Sandwich Place | Pizza Place | Pharmacy | Hospital | Japanese Restaurant | Smoothie Shop | Shopping Plaza | Pet Store |
| 51 | Rivers End | Playground | Intersection | Fast Food Restaurant | Cosmetics Shop | Convenience Store | Cupcake Shop | Drive-in Theater | Food & Drink Shop | Food | Flower Shop |
| 52 | Rose Dhu | Campground | Women's Store | Drive-in Theater | Food Truck | Food & Drink Shop | Food | Flower Shop | Fish Market | Fast Food Restaurant | Farmers Market |
| 53 | Savannah Gardens | Convenience Store | Park | Liquor Store | Bar | Seafood Restaurant | Golf Course | Dessert Shop | Department Store | Food | Flower Shop |
| 54 | Savannah State University | Harbor / Marina | Seafood Restaurant | American Restaurant | Sporting Goods Shop | Women's Store | Drive-in Theater | Food & Drink Shop | Food | Flower Shop | Fish Market |
| 55 | Shirley Park | Chinese Restaurant | Shopping Mall | Gas Station | Seafood Restaurant | Discount Store | Intersection | Supermarket | Dessert Shop | Food | Sports Bar |
| 56 | South Garden | Candy Store | Southern / Soul Food Restaurant | Lounge | Gourmet Shop | Hotel | Plaza | Park | New American Restaurant | Seafood Restaurant | Boutique |
| 57 | Southover | Brewery | Discount Store | Vegetarian / Vegan Restaurant | Bakery | Women's Store | Electronics Store | Food & Drink Shop | Food | Flower Shop | Fish Market |
| 58 | Sunset Park | Sports Bar | Fried Chicken Joint | Fast Food Restaurant | Coffee Shop | Pharmacy | Pizza Place | Discount Store | Thai Restaurant | Big Box Store | Donut Shop |
| 59 | Sylvan Terrace | Harbor / Marina | Boat or Ferry | Scenic Lookout | Women's Store | Donut Shop | Food & Drink Shop | Food | Flower Shop | Fish Market | Fast Food Restaurant |
| 60 | Thomas Square | Gourmet Shop | Pharmacy | Pub | River | Dive Bar | Flower Shop | Fish Market | Fast Food Restaurant | Farmers Market | Farm |
| 61 | Tremont Park | Gas Station | Discount Store | Convenience Store | Intersection | Food | Fast Food Restaurant | Grocery Store | Construction & Landscaping | Deli / Bodega | Wine Bar |
| 62 | Victory Heights | Chinese Restaurant | Mobile Phone Shop | Fast Food Restaurant | Pizza Place | Coffee Shop | Pharmacy | Big Box Store | Restaurant | Mexican Restaurant | Fried Chicken Joint |
| 63 | Victory Manor | Pizza Place | Coffee Shop | Chinese Restaurant | Mexican Restaurant | Sandwich Place | Hardware Store | Donut Shop | Big Box Store | Breakfast Spot | Fast Food Restaurant |
| 64 | Victory Square | Chinese Restaurant | Mobile Phone Shop | Fast Food Restaurant | Pizza Place | Coffee Shop | Pharmacy | Big Box Store | Restaurant | Mexican Restaurant | Fried Chicken Joint |
| 65 | West Savannah | Pizza Place | Discount Store | Grocery Store | Ice Cream Shop | Supermarket | Sandwich Place | BBQ Joint | Construction & Landscaping | Department Store | Drive-in Theater |
| 66 | Windsor Forest | Pizza Place | Intersection | Convenience Store | Sandwich Place | Fast Food Restaurant | Building | Mediterranean Restaurant | Storage Facility | Gas Station | BBQ Joint |
| 67 | Winter Gardens | Pool | Soccer Field | Video Game Store | Women's Store | Dog Run | Flower Shop | Fish Market | Fast Food Restaurant | Farmers Market | Farm |
| 68 | Yamacraw Village | Museum | Plaza | Dessert Shop | Hotel | Tourist Information Center | Lounge | Market | Brewery | Restaurant | Diner |
Table 2. Jacksonville Venues
Jacksonville_data=A_neighborhoods_venues_sorted
Jacksonville_data
| Neighborhood | 1st Most Common Venue | 2nd Most Common Venue | 3rd Most Common Venue | 4th Most Common Venue | 5th Most Common Venue | 6th Most Common Venue | 7th Most Common Venue | 8th Most Common Venue | 9th Most Common Venue | 10th Most Common Venue | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Arlington | Video Store | Restaurant | ATM | Italian Restaurant | Mexican Restaurant | Shopping Mall | Seafood Restaurant | Sandwich Place | Fried Chicken Joint | Bookstore |
| 1 | Avondale | Park | Pizza Place | Convenience Store | Gaming Cafe | Plaza | Deli / Bodega | New American Restaurant | Coffee Shop | Chinese Restaurant | Smoke Shop |
| 2 | Belfort Station | Hotel | Sandwich Place | Automotive Shop | Cocktail Bar | Chinese Restaurant | Food Truck | Gas Station | Japanese Restaurant | Italian Restaurant | Mexican Restaurant |
| 3 | Brooklyn | Café | Park | Deli / Bodega | Gym / Fitness Center | Gym | Smoothie Shop | Sandwich Place | Concert Hall | Plaza | Playground |
| 4 | Church District | Grocery Store | Pizza Place | Japanese Restaurant | Intersection | Spa | Shopping Mall | Pharmacy | Liquor Store | Shipping Store | Sandwich Place |
| 5 | Downtown | Bakery | History Museum | Truck Stop | Gas Station | Bar | Italian Restaurant | Greek Restaurant | Rest Area | American Restaurant | Dive Bar |
| 6 | East Jacksonville | Fast Food Restaurant | Video Store | Light Rail Station | Train Station | Sandwich Place | Bakery | Zoo | Event Service | Flea Market | Farmers Market |
| 7 | Empire Point | Chiropractor | Lawyer | American Restaurant | Rental Car Location | Gas Station | Baseball Field | Donut Shop | Flea Market | Fast Food Restaurant | Farmers Market |
| 8 | Mandarin | Event Service | Pet Store | Business Service | Farmers Market | Park | Food Truck | Flea Market | Fast Food Restaurant | Exhibit | Zoo |
| 9 | North Jacksonville | Fast Food Restaurant | Video Store | Light Rail Station | Train Station | Sandwich Place | Bakery | Zoo | Event Service | Flea Market | Farmers Market |
| 10 | Oakland | Bar | Rental Car Location | Park | Italian Restaurant | Café | Flea Market | Burrito Place | Food Truck | Soccer Stadium | Brewery |
| 11 | Ortega | Park | Harbor / Marina | Home Service | Jewelry Store | Pharmacy | Flower Shop | Garden Center | Bank | Diner | Trail |
| 12 | River Park | Coffee Shop | Art Gallery | Café | Mexican Restaurant | Food Truck | Brewery | Burrito Place | Sandwich Place | Lounge | Comfort Food Restaurant |
| 13 | Riverside | American Restaurant | Sushi Restaurant | Sandwich Place | Restaurant | Bar | Coffee Shop | Record Shop | Cosmetics Shop | Smoothie Shop | Cocktail Bar |
| 14 | San Marco | Coffee Shop | American Restaurant | Mediterranean Restaurant | Sandwich Place | Brewery | Restaurant | Speakeasy | Diner | Café | Mexican Restaurant |
| 15 | Sherwood Forest | Music Venue | Discount Store | Zoo | Exhibit | Food Truck | Flower Shop | Flea Market | Fast Food Restaurant | Farmers Market | Event Service |
| 16 | South Jacksonville | Hotel | Mediterranean Restaurant | Mexican Restaurant | Coffee Shop | Sandwich Place | Resort | Sports Bar | Café | Cocktail Bar | Pizza Place |
| 17 | South Side | Park | Pizza Place | Baseball Field | Salon / Barbershop | Photography Studio | Disc Golf | Donut Shop | Shipping Store | Chinese Restaurant | Music Venue |
| 18 | Springfield | Zoo | Exhibit | Flower Shop | Tea Room | Deli / Bodega | Discount Store | Dive Bar | Dog Run | Donut Shop | French Restaurant |
| 19 | Stadium District | Stadium | American Restaurant | Fast Food Restaurant | Pizza Place | Pet Store | Coffee Shop | General Entertainment | Burger Joint | Shipping Store | Juice Bar |
| 20 | Waterleaf | Food Truck | Intersection | Photography Studio | Disc Golf | Discount Store | Diner | Dive Bar | Dog Run | French Restaurant | Donut Shop |
| 21 | West Jacksonville | Home Service | Cosmetics Shop | Middle Eastern Restaurant | Intersection | Sandwich Place | Cafeteria | Caribbean Restaurant | Zoo | Farmers Market | Flea Market |
Table 3. County Health Rankings
Reference: https://www.countyhealthrankings.org/app/georgia/2020/compare/snapshot?counties=12_031%2013_051
County_Table
| Unnamed: 0 | Duval (DU) , FL | Chatham (CA) , GA | |
|---|---|---|---|
| 0 | Demographics | ||
| 1 | Population | 950,181 | 289,195 |
| 2 | % below 18 years of age | 22.60% | 21.20% |
| 3 | % 65 and older | 14.00% | 15.40% |
| 4 | % Non-Hispanic Black | 29.50% | 40.10% |
| 5 | % American Indian & Alaska Native | 0.50% | 0.40% |
| 6 | % Asian | 5.10% | 2.90% |
| 7 | % Native Hawaiian/Other Pacific Islander | 0.10% | 0.10% |
| 8 | % Hispanic | 10.10% | 6.60% |
| 9 | % Non-Hispanic White | 52.60% | 48.20% |
| 10 | % not proficient in English | 3% | 1% |
| 11 | % Females | 51.50% | 51.90% |
| 12 | % Rural | 2.90% | 4.50% |
| 13 | Length of Life | ||
| 14 | Life expectancy | 76.2 | 77.9 |
| 15 | Premature age-adjusted mortality | 440 | 400 |
| 16 | Child mortality | 80 | 80 |
| 17 | Infant mortality | 9 | 7 |
| 18 | Quality of Life | ||
| 19 | Frequent physical distress | 13% | 11% |
| 20 | Frequent mental distress | 13% | 12% |
| 21 | Diabetes prevalence | 12% | 10% |
| 22 | HIV prevalence | 761 | 702 |
| 23 | Health Behaviors | ||
| 24 | Food insecurity | 18% | 17% |
| 25 | Limited access to healthy foods | 9% | 7% |
| 26 | Drug overdose deaths | 41 | 13 |
| 27 | Motor vehicle crash deaths | 15 | 12 |
| 28 | Insufficient sleep | 37% | 38% |
| 29 | Clinical Care | ||
| ... | ... | ... | ... |
| 46 | Traffic volume | 422 | 362 |
| 47 | Homeownership | 57% | 54% |
| 48 | Severe housing cost burden | 16% | 17% |
| 49 | Health Outcomes | ||
| 50 | Length of Life | ||
| 51 | Premature death | 9,700 | 8,300 |
| 52 | Quality of Life | ||
| 53 | Poor or fair health | 19% | 18% |
| 54 | Poor physical health days | 4.3 | 3.4 |
| 55 | Poor mental health days | 4.3 | 3.7 |
| 56 | Low birthweight | 10% | 10% |
| 57 | Health Factors | ||
| 58 | Health Behaviors | ||
| 59 | Adult smoking | 20% | 17% |
| 60 | Adult obesity | 31% | 32% |
| 61 | Food environment index | 6.6 | 6.9 |
| 62 | Physical inactivity | 26% | 26% |
| 63 | Access to exercise opportunities | 92% | 90% |
| 64 | Excessive drinking | 19% | 17% |
| 65 | Alcohol-impaired driving deaths | 29% | 21% |
| 66 | Sexually transmitted infections | 738.3 | 876.8 |
| 67 | Teen births | 29 | 25 |
| 68 | Clinical Care | ||
| 69 | Uninsured | 13% | 16% |
| 70 | Primary care physicians | 1,160:1 | 1,130:1 |
| 71 | Dentists | 1,220:1 | 1,500:1 |
| 72 | Mental health providers | 510:01:00 | 690:01:00 |
| 73 | Preventable hospital stays | 5,911 | 4,502 |
| 74 | Mammography screening | 41% | 47% |
| 75 | Flu vaccinations | 43% | 45% |
76 rows × 3 columns
Table 4. Death by Age New York
Reference:https://www.worldometers.info/coronavirus/coronavirus-age-sex-demographics/
Death_by_Age_Table
| AGE | Number of Deaths | Share of deaths | With underlying conditions | Without underlying conditions | Unknown if with underlying cond. | Share of deaths of unknown + w/o cond. | |
|---|---|---|---|---|---|---|---|
| 0 | 0 - 17 years old | 9 | 0.06% | 6 | 3 | 0 | 0.02% |
| 1 | 18 - 44 years old | 601 | 3.90% | 476 | 17 | 108 | 0.80% |
| 2 | 45 - 64 years old | 3,413 | 22.40% | 2,851 | 72 | 490 | 3.70% |
| 3 | 65 - 74 years old | 3,788 | 24.90% | 2,801 | 5 | 982 | 6.50% |
| 4 | 75+ years old | 7,419 | 48.70% | 5,236 | 2 | 2,181 | 14.30% |
| 5 | TOTAL | 15,230 | 100% | 11,370 (75%) | 99 (0.7%) | 1,551 (24.7%) | 25.30% |
Table 5. Capacity and Fatality Rates
Reference:https://bao.arcgis.com/covid-19/jhu/county/13051.html
Capacity_Table
| Description | Duval | Chatham | Queens | |
|---|---|---|---|---|
| 0 | Number of Beds | 3,456 | 1,569 | 3,210 |
| 1 | Cases per 100,000 | 128 | 119 | 2,521 |
| 2 | Confirmed Cases | 1,215 | 344 | 57,459 |
| 3 | Deaths | 32 | 14 | 4,595 |
| 4 | Fatality Rate | 2.6% | 4% | 8% |
For all rates by county go to: Capacity
Based on venues in Savannah(Table 1) and Jacksonville(Table 2) there are many businesses/venues that will be significantly impacted by economic shutdown. In North Jacksonville and East Jacksonville, fast food restaurants account for about 38% of venues. In East Savannah, pizza places(18%) and discount stores(18%) account for 36% of venues while in Southover, Savannah bakeries(25%), breweries(25%), and discount stores(25%) account for 75% of venues. With so many businesses impacted will reopening be risky? If we take a look at county health rankings(Table 3), only 14-15% of the population is 65 and over indicating a small high-risk population(Table 4) with about 75% of deaths occurring in people 65+. Additionally, access to exercise opportunities are about 90% indicating the ability for most of the population to engage in immune and health boosting activities which is important to improve the obesity rate at 31%. However, we do need to factor in smoking at 20% which increases the risk for complications for Coronavirus. Is there medical capacity for handling increase in cases? According to Johns Hopkins University, capacity and fatality rates(Table 5), Duval and Chatham counties fall well below the averages of Queens, New York. Although New York was initial site, at this point Jacksonville and Savannah have relatively low numbers of infections with a significant number of beds available.
The governors of Jacksonville and Savannah should consider the pros and cons of opening up too soon. As Table 5 indicates, the rate of infections and fatalities are relatively low especially for Duval county of Jacksonville. Chatham county has a higher rate but still half of Queens, New York which is the epicenter of the virus. With a population of about 300K, Chatham may fare better than other counties because of the relatively small population and vulnerable population at approximately 15%(65+). Governors have considered opening places at 25% capacity but many businesses can't be profitable at such low capacity. Another suggestion is perhaps sustain stay-at-home orders for vulnerable populations. Businesses like gyms may significantly lower the risks by permitting those under 65 at full capacity with significant cleaning measures. For schools, the most vulnerable populations continue to work online while the least can go back to the classroom. Allow the least vulnerable populations to get back to work and subsidize the ones that need to stay at home.
neighborhoods
| City | Neighborhood | Latitude | Longitude | |
|---|---|---|---|---|
| 0 | Savannah | Avalon | 32.050010 | -81.066843 |
| 1 | Savannah | Avondale | 32.052988 | -81.057612 |
| 2 | Savannah | Baldwin Park | 32.050870 | -81.091097 |
| 3 | Savannah | Bartow | 32.086596 | -81.124556 |
| 4 | Savannah | Bayview | 30.224534 | -85.682356 |
| 5 | Savannah | Beach Institute | 32.068951 | -81.089268 |
| 6 | Savannah | Berkshire Woods | 31.961601 | -81.153999 |
| 7 | Savannah | Bingville | 32.046542 | -81.109500 |
| 8 | Savannah | Blueberry Hill | 32.344312 | -80.886251 |
| 9 | Savannah | Brookview | 32.004379 | -81.074279 |
| 10 | Savannah | Cann Park | 32.053430 | -81.113216 |
| 11 | Savannah | Carver Heights | 32.060826 | -81.099685 |
| 12 | Savannah | Chatham Crescent | 32.050783 | -81.096504 |
| 13 | Savannah | Chatham Parkway | 32.062359 | -81.160074 |
| 14 | Savannah | Chippewa | 31.998822 | -81.116223 |
| 15 | Savannah | Cloverdale | 32.066874 | -81.129001 |
| 16 | Savannah | Coffee Bluff | 31.936879 | -81.153165 |
| 17 | Savannah | Colonial Oaks | 31.962156 | -81.148444 |
| 18 | Savannah | Colonial Village | 31.962156 | -81.148444 |
| 19 | Savannah | Dawes Avenue | 32.055294 | -81.126188 |
| 20 | Savannah | Dixon Park | 32.060809 | -81.090965 |
| 21 | Savannah | Downtown Savannah | 32.075275 | -81.098580 |
| 22 | Savannah | East Savannah | 39.941368 | -94.829946 |
| 23 | Savannah | Eastside | 32.046452 | -81.066779 |
| 24 | Savannah | Edgemere | 32.039377 | -81.087612 |
| 25 | Savannah | Fairfield | 32.032710 | -81.090667 |
| 26 | Savannah | Fairway Oaks | 32.019933 | -81.095945 |
| 27 | Savannah | Fernwood | 32.032155 | -81.064279 |
| 28 | Savannah | Forest Park | 32.080926 | -81.091177 |
| 29 | Savannah | Forest Ridge | 32.080926 | -81.091177 |
| 30 | Savannah | Habersham Woods | 32.019655 | -81.107056 |
| 31 | Savannah | Highland Park | 32.009656 | -81.100390 |
| 32 | Savannah | Hillcrest | 37.727200 | -84.269892 |
| 33 | Savannah | Hitch Village | 32.073000 | -81.094000 |
| 34 | Savannah | Jackson Park | 35.309266 | -83.259593 |
| 35 | Savannah | Kayton | 32.069785 | -81.104518 |
| 36 | Savannah | Kensington Park | 32.023544 | -81.101779 |
| 37 | Savannah | Laurel Grove | 32.063056 | -81.111917 |
| 38 | Savannah | Live Oak | 32.083880 | -81.195388 |
| 39 | Savannah | Mayfair | 31.992990 | -81.094278 |
| 40 | Savannah | Medical Arts | 32.031369 | -81.094137 |
| 41 | Savannah | Metropolitan | -33.451491 | -70.731706 |
| 42 | Savannah | Oakdale | 32.017989 | -81.100390 |
| 43 | Savannah | Oakhurst | 31.995489 | -81.124001 |
| 44 | Savannah | Oakland Park | 32.034933 | -81.075390 |
| 45 | Savannah | Oglethorpe | 32.076763 | -81.096973 |
| 46 | Savannah | Paradise Park | 33.713487 | -117.766140 |
| 47 | Savannah | Parkside | 32.274694 | -80.926254 |
| 48 | Savannah | Pine Gardens | 32.066320 | -81.060112 |
| 49 | Savannah | Poplar Place | 35.238418 | -88.244227 |
| 50 | Savannah | Ridgewood | 32.033543 | -81.098445 |
| 51 | Savannah | Rivers End | 31.986878 | -81.115389 |
| 52 | Savannah | Rose Dhu | 31.927992 | -81.133720 |
| 53 | Savannah | Savannah Gardens | 32.061321 | -81.060945 |
| 54 | Savannah | Savannah State University | 32.022924 | -81.056107 |
| 55 | Savannah | Shirley Park | 32.024100 | -81.079279 |
| 56 | Savannah | South Garden | 32.080926 | -81.091177 |
| 57 | Savannah | Southover | 32.046875 | -81.127056 |
| 58 | Savannah | Sunset Park | 32.034933 | -81.065945 |
| 59 | Savannah | Sylvan Terrace | 32.019657 | -81.042890 |
| 60 | Savannah | Thomas Square | 31.816875 | -81.358855 |
| 61 | Savannah | Tremont Park | 32.059930 | -81.137890 |
| 62 | Savannah | Victory Heights | 32.042155 | -81.061779 |
| 63 | Savannah | Victory Manor | 32.045460 | -81.072134 |
| 64 | Savannah | Victory Square | 32.042155 | -81.061779 |
| 65 | Savannah | West Savannah | 39.941368 | -94.829946 |
| 66 | Savannah | Windsor Forest | 31.976601 | -81.132333 |
| 67 | Savannah | Winter Gardens | 32.174785 | -81.245293 |
| 68 | Savannah | Yamacraw Village | 32.081612 | -81.100310 |
neighborhoods
| City | Neighborhood | Latitude | Longitude | |
|---|---|---|---|---|
| 0 | Jacksonville | Arlington | 30.335795 | -81.602871 |
| 1 | Jacksonville | Avondale | 30.304406 | -81.711209 |
| 2 | Jacksonville | Belfort Station | 30.251119 | -81.584455 |
| 3 | Jacksonville | Brooklyn | 30.323573 | -81.674541 |
| 4 | Jacksonville | Church District | 30.280525 | -81.490998 |
| 5 | Jacksonville | Downtown | 30.326066 | -81.656353 |
| 6 | Jacksonville | East Jacksonville | 30.365447 | -81.723926 |
| 7 | Jacksonville | Empire Point | 30.313700 | -81.615915 |
| 8 | Jacksonville | Mandarin | 30.160519 | -81.659260 |
| 9 | Jacksonville | North Jacksonville | 30.365447 | -81.723926 |
| 10 | Jacksonville | Oakland | 30.331445 | -81.647625 |
| 11 | Jacksonville | Ortega | 30.270517 | -81.708152 |
| 12 | Jacksonville | River Park | 30.332184 | -81.655651 |
| 13 | Jacksonville | Riverside | 30.312184 | -81.684263 |
| 14 | Jacksonville | San Marco | 30.304562 | -81.650829 |
| 15 | Jacksonville | Sherwood Forest | 30.409961 | -81.724266 |
| 16 | Jacksonville | South Jacksonville | 30.311073 | -81.645650 |
| 17 | Jacksonville | South Side | 30.369820 | -81.506404 |
| 18 | Jacksonville | Springfield | 40.050389 | -74.763495 |
| 19 | Jacksonville | Stadium District | 30.275187 | -81.511868 |
| 20 | Jacksonville | Waterleaf | 30.336679 | -81.492715 |
| 21 | Jacksonville | West Jacksonville | 30.340239 | -81.722321 |
num_top_venues = 10
for hood in A_grouped['Neighborhood']:
print("----"+hood+"----")
temp = A_grouped[A_grouped['Neighborhood'] == hood].T.reset_index()
temp.columns = ['venue','freq']
temp = temp.iloc[1:]
temp['freq'] = temp['freq'].astype(float)
temp = temp.round({'freq': 2})
print(temp.sort_values('freq', ascending=False).reset_index(drop=True).head(num_top_venues))
print('\n')
----Avalon----
venue freq
0 Chinese Restaurant 0.07
1 Pizza Place 0.07
2 Mexican Restaurant 0.07
3 Mobile Phone Shop 0.07
4 Sandwich Place 0.07
5 Fried Chicken Joint 0.03
6 Gym / Fitness Center 0.03
7 Grocery Store 0.03
8 Greek Restaurant 0.03
9 Deli / Bodega 0.03
----Avondale----
venue freq
0 Food 0.14
1 Park 0.14
2 Intersection 0.07
3 Historic Site 0.07
4 General Travel 0.07
5 Skating Rink 0.07
6 Seafood Restaurant 0.07
7 Liquor Store 0.07
8 Tour Provider 0.07
9 Fast Food Restaurant 0.07
----Baldwin Park----
venue freq
0 Gas Station 0.10
1 Park 0.10
2 Intersection 0.07
3 Southern / Soul Food Restaurant 0.07
4 American Restaurant 0.07
5 Playground 0.07
6 Antique Shop 0.03
7 Coffee Shop 0.03
8 Sporting Goods Shop 0.03
9 Middle Eastern Restaurant 0.03
----Bartow----
venue freq
0 Discount Store 0.2
1 Pet Store 0.2
2 Seafood Restaurant 0.1
3 American Restaurant 0.1
4 Park 0.1
5 Chinese Restaurant 0.1
6 Grocery Store 0.1
7 Shipping Store 0.1
8 Outdoors & Recreation 0.0
9 Moving Target 0.0
----Bayview----
venue freq
0 Garden 0.25
1 Construction & Landscaping 0.25
2 Kids Store 0.25
3 Drive-in Theater 0.25
4 Pizza Place 0.00
5 Outdoors & Recreation 0.00
6 Mobile Phone Shop 0.00
7 Moving Target 0.00
8 Multiplex 0.00
9 Museum 0.00
----Beach Institute----
venue freq
0 Plaza 0.23
1 Park 0.07
2 Bed & Breakfast 0.07
3 Italian Restaurant 0.03
4 Farmers Market 0.03
5 Museum 0.03
6 Breakfast Spot 0.03
7 Fountain 0.03
8 Tea Room 0.03
9 History Museum 0.03
----Berkshire Woods----
venue freq
0 Park 0.4
1 Home Service 0.2
2 Photography Studio 0.2
3 Coffee Shop 0.2
4 Yoga Studio 0.0
5 Optical Shop 0.0
6 Middle Eastern Restaurant 0.0
7 Mobile Phone Shop 0.0
8 Moving Target 0.0
9 Multiplex 0.0
----Bingville----
venue freq
0 Convenience Store 0.13
1 Park 0.13
2 Discount Store 0.09
3 Bar 0.04
4 Electronics Store 0.04
5 Fast Food Restaurant 0.04
6 Seafood Restaurant 0.04
7 Coffee Shop 0.04
8 Chinese Restaurant 0.04
9 Outdoors & Recreation 0.04
----Blueberry Hill----
venue freq
0 Farm 1.0
1 Yoga Studio 0.0
2 IT Services 0.0
3 Middle Eastern Restaurant 0.0
4 Mobile Phone Shop 0.0
5 Moving Target 0.0
6 Multiplex 0.0
7 Museum 0.0
8 New American Restaurant 0.0
9 Nightclub 0.0
----Brookview----
venue freq
0 Intersection 0.18
1 Chinese Restaurant 0.18
2 Thrift / Vintage Store 0.09
3 Southern / Soul Food Restaurant 0.09
4 Furniture / Home Store 0.09
5 Golf Course 0.09
6 Construction & Landscaping 0.09
7 Food & Drink Shop 0.09
8 Food 0.09
9 Multiplex 0.00
----Cann Park----
venue freq
0 Bakery 0.10
1 Intersection 0.07
2 Discount Store 0.07
3 Chinese Restaurant 0.07
4 Seafood Restaurant 0.07
5 Convenience Store 0.07
6 Park 0.07
7 Bar 0.03
8 Thrift / Vintage Store 0.03
9 Mobile Phone Shop 0.03
----Carver Heights----
venue freq
0 Coffee Shop 0.10
1 American Restaurant 0.07
2 Restaurant 0.07
3 Seafood Restaurant 0.07
4 Park 0.07
5 Café 0.07
6 Yoga Studio 0.03
7 Beer Store 0.03
8 Playground 0.03
9 Farmers Market 0.03
----Chatham Crescent----
venue freq
0 American Restaurant 0.07
1 Antique Shop 0.07
2 Seafood Restaurant 0.07
3 Café 0.07
4 Middle Eastern Restaurant 0.03
5 Spa 0.03
6 Brewery 0.03
7 Plaza 0.03
8 Burger Joint 0.03
9 Greek Restaurant 0.03
----Chatham Parkway----
venue freq
0 Gym 0.22
1 Gun Range 0.11
2 Italian Restaurant 0.11
3 Japanese Restaurant 0.11
4 Jewelry Store 0.11
5 Breakfast Spot 0.11
6 Sandwich Place 0.11
7 Fast Food Restaurant 0.11
8 Noodle House 0.00
9 Optical Shop 0.00
----Chippewa----
venue freq
0 Cosmetics Shop 0.10
1 Department Store 0.10
2 Lingerie Store 0.10
3 Furniture / Home Store 0.07
4 Deli / Bodega 0.03
5 Bakery 0.03
6 Fried Chicken Joint 0.03
7 Mobile Phone Shop 0.03
8 Supermarket 0.03
9 Mexican Restaurant 0.03
----Cloverdale----
venue freq
0 Park 0.33
1 Intersection 0.17
2 Moving Target 0.17
3 Construction & Landscaping 0.17
4 Road 0.17
5 Outlet Mall 0.00
6 Mobile Phone Shop 0.00
7 Multiplex 0.00
8 Museum 0.00
9 New American Restaurant 0.00
----Coffee Bluff----
venue freq
0 Playground 0.5
1 Harbor / Marina 0.5
2 Yoga Studio 0.0
3 Outdoors & Recreation 0.0
4 Middle Eastern Restaurant 0.0
5 Mobile Phone Shop 0.0
6 Moving Target 0.0
7 Multiplex 0.0
8 Museum 0.0
9 New American Restaurant 0.0
----Colonial Oaks----
venue freq
0 Park 0.2
1 Construction & Landscaping 0.2
2 Home Service 0.2
3 Coffee Shop 0.2
4 Photography Studio 0.2
5 Outdoors & Recreation 0.0
6 Mobile Phone Shop 0.0
7 Moving Target 0.0
8 Multiplex 0.0
9 Museum 0.0
----Colonial Village----
venue freq
0 Park 0.2
1 Construction & Landscaping 0.2
2 Home Service 0.2
3 Coffee Shop 0.2
4 Photography Studio 0.2
5 Outdoors & Recreation 0.0
6 Mobile Phone Shop 0.0
7 Moving Target 0.0
8 Multiplex 0.0
9 Museum 0.0
----Dawes Avenue----
venue freq
0 Discount Store 0.33
1 Deli / Bodega 0.11
2 Brewery 0.11
3 Construction & Landscaping 0.11
4 Sandwich Place 0.11
5 Grocery Store 0.11
6 Bakery 0.11
7 Outlet Mall 0.00
8 Multiplex 0.00
9 Museum 0.00
----Dixon Park----
venue freq
0 Coffee Shop 0.10
1 American Restaurant 0.07
2 Restaurant 0.07
3 Park 0.07
4 Historic Site 0.07
5 BBQ Joint 0.07
6 Yoga Studio 0.03
7 Burger Joint 0.03
8 Beer Store 0.03
9 Taco Place 0.03
----Downtown Savannah----
venue freq
0 Plaza 0.23
1 Bistro 0.10
2 History Museum 0.07
3 Southern / Soul Food Restaurant 0.07
4 Pub 0.03
5 Tour Provider 0.03
6 Museum 0.03
7 Gym 0.03
8 Coffee Shop 0.03
9 Bookstore 0.03
----East Savannah----
venue freq
0 Discount Store 0.25
1 Supermarket 0.12
2 BBQ Joint 0.12
3 Ice Cream Shop 0.12
4 Sandwich Place 0.12
5 Grocery Store 0.12
6 Pizza Place 0.12
7 Kitchen Supply Store 0.00
8 Paper / Office Supplies Store 0.00
9 Multiplex 0.00
----Eastside----
venue freq
0 Pizza Place 0.07
1 Park 0.07
2 Sandwich Place 0.07
3 Coffee Shop 0.07
4 Chinese Restaurant 0.07
5 Breakfast Spot 0.03
6 Mobile Phone Shop 0.03
7 Gym / Fitness Center 0.03
8 Grocery Store 0.03
9 Greek Restaurant 0.03
----Edgemere----
venue freq
0 Park 0.24
1 Baseball Field 0.12
2 Coffee Shop 0.06
3 Playground 0.06
4 Tennis Court 0.06
5 Lawyer 0.06
6 Laundry Service 0.06
7 Salon / Barbershop 0.06
8 Plaza 0.06
9 Sporting Goods Shop 0.06
----Fairfield----
venue freq
0 Pharmacy 0.13
1 Sandwich Place 0.10
2 Gas Station 0.07
3 Café 0.07
4 Pizza Place 0.07
5 Japanese Restaurant 0.03
6 Burrito Place 0.03
7 Southern / Soul Food Restaurant 0.03
8 Caribbean Restaurant 0.03
9 Supplement Shop 0.03
----Fairway Oaks----
venue freq
0 Pharmacy 0.14
1 Fast Food Restaurant 0.09
2 Breakfast Spot 0.05
3 Gas Station 0.05
4 Pizza Place 0.05
5 Café 0.05
6 Caribbean Restaurant 0.05
7 Shopping Mall 0.05
8 Gym 0.05
9 Tanning Salon 0.05
----Fernwood----
venue freq
0 Discount Store 0.10
1 Convenience Store 0.10
2 American Restaurant 0.07
3 Sports Bar 0.07
4 Pizza Place 0.03
5 Theater 0.03
6 Multiplex 0.03
7 Donut Shop 0.03
8 Shopping Mall 0.03
9 Fried Chicken Joint 0.03
----Forest Park----
venue freq
0 Candy Store 0.10
1 Plaza 0.07
2 Southern / Soul Food Restaurant 0.07
3 Lounge 0.07
4 Hotel 0.07
5 Gourmet Shop 0.07
6 Seafood Restaurant 0.03
7 Boutique 0.03
8 Dive Bar 0.03
9 Museum 0.03
----Forest Ridge----
venue freq
0 Candy Store 0.10
1 Plaza 0.07
2 Southern / Soul Food Restaurant 0.07
3 Lounge 0.07
4 Hotel 0.07
5 Gourmet Shop 0.07
6 Seafood Restaurant 0.03
7 Boutique 0.03
8 Dive Bar 0.03
9 Museum 0.03
----Habersham Woods----
venue freq
0 Hotel 0.20
1 Grocery Store 0.07
2 Coffee Shop 0.07
3 Seafood Restaurant 0.03
4 Men's Store 0.03
5 Burger Joint 0.03
6 Furniture / Home Store 0.03
7 Shopping Plaza 0.03
8 Optical Shop 0.03
9 Women's Store 0.03
----Highland Park----
venue freq
0 Asian Restaurant 0.10
1 Multiplex 0.07
2 American Restaurant 0.07
3 Ice Cream Shop 0.07
4 Sandwich Place 0.07
5 Sushi Restaurant 0.07
6 Spa 0.03
7 Fried Chicken Joint 0.03
8 Massage Studio 0.03
9 Chinese Restaurant 0.03
----Hillcrest----
venue freq
0 Cosmetics Shop 0.09
1 Intersection 0.09
2 Discount Store 0.09
3 Gym 0.09
4 BBQ Joint 0.05
5 Sports Bar 0.05
6 Supermarket 0.05
7 Fried Chicken Joint 0.05
8 Chinese Restaurant 0.05
9 Seafood Restaurant 0.05
----Hitch Village----
venue freq
0 Plaza 0.23
1 Coffee Shop 0.07
2 Bookstore 0.07
3 Bistro 0.07
4 Food & Drink Shop 0.03
5 Breakfast Spot 0.03
6 Cocktail Bar 0.03
7 Tea Room 0.03
8 Bed & Breakfast 0.03
9 Fountain 0.03
----Jackson Park----
venue freq
0 BBQ Joint 0.5
1 River 0.5
2 Outlet Mall 0.0
3 Middle Eastern Restaurant 0.0
4 Mobile Phone Shop 0.0
5 Moving Target 0.0
6 Multiplex 0.0
7 Museum 0.0
8 New American Restaurant 0.0
9 Nightclub 0.0
----Kayton----
venue freq
0 Plaza 0.10
1 Museum 0.07
2 Coffee Shop 0.07
3 Fried Chicken Joint 0.07
4 Bed & Breakfast 0.07
5 Bar 0.07
6 Tour Provider 0.03
7 Gaming Cafe 0.03
8 Playground 0.03
9 Gym 0.03
----Kensington Park----
venue freq
0 Hotel 0.10
1 Café 0.07
2 Pharmacy 0.07
3 Grocery Store 0.07
4 Salon / Barbershop 0.03
5 Caribbean Restaurant 0.03
6 Furniture / Home Store 0.03
7 Burger Joint 0.03
8 Southern / Soul Food Restaurant 0.03
9 Pizza Place 0.03
----Laurel Grove----
venue freq
0 Fried Chicken Joint 0.2
1 Park 0.2
2 Bakery 0.2
3 Mobile Phone Shop 0.1
4 Intersection 0.1
5 Auto Workshop 0.1
6 Seafood Restaurant 0.1
7 Outdoors & Recreation 0.0
8 Moving Target 0.0
9 Multiplex 0.0
----Live Oak----
venue freq
0 Convenience Store 0.33
1 Construction & Landscaping 0.33
2 Hobby Shop 0.33
3 Yoga Studio 0.00
4 Outlet Mall 0.00
5 Mobile Phone Shop 0.00
6 Moving Target 0.00
7 Multiplex 0.00
8 Museum 0.00
9 New American Restaurant 0.00
----Mayfair----
venue freq
0 Thrift / Vintage Store 0.11
1 Kids Store 0.11
2 Park 0.11
3 Track 0.11
4 Lake 0.11
5 Baseball Field 0.11
6 Bike Rental / Bike Share 0.11
7 Pool 0.11
8 Bar 0.11
9 New American Restaurant 0.00
----Medical Arts----
venue freq
0 Sandwich Place 0.10
1 Pharmacy 0.10
2 Café 0.07
3 Pizza Place 0.07
4 Coffee Shop 0.07
5 Yoga Studio 0.03
6 Southern / Soul Food Restaurant 0.03
7 Smoothie Shop 0.03
8 Breakfast Spot 0.03
9 Gas Station 0.03
----Metropolitan----
venue freq
0 Bus Station 0.14
1 Metro Station 0.09
2 Nightclub 0.09
3 Food 0.09
4 Pizza Place 0.05
5 Sandwich Place 0.05
6 Soccer Stadium 0.05
7 Soccer Field 0.05
8 Food Truck 0.05
9 Gym 0.05
----Oakdale----
venue freq
0 Pharmacy 0.12
1 Video Store 0.08
2 Deli / Bodega 0.04
3 Grocery Store 0.04
4 Mexican Restaurant 0.04
5 Multiplex 0.04
6 Burger Joint 0.04
7 Gas Station 0.04
8 Shopping Mall 0.04
9 Coffee Shop 0.04
----Oakhurst----
venue freq
0 Sandwich Place 0.07
1 Discount Store 0.07
2 Furniture / Home Store 0.03
3 Supermarket 0.03
4 Storage Facility 0.03
5 Electronics Store 0.03
6 Smoothie Shop 0.03
7 Shopping Mall 0.03
8 Clothing Store 0.03
9 Deli / Bodega 0.03
----Oakland Park----
venue freq
0 Discount Store 0.11
1 American Restaurant 0.07
2 Clothing Store 0.07
3 Sports Bar 0.04
4 Sandwich Place 0.04
5 Multiplex 0.04
6 Shopping Mall 0.04
7 Shoe Store 0.04
8 Chinese Restaurant 0.04
9 Paper / Office Supplies Store 0.04
----Oglethorpe----
venue freq
0 Plaza 0.20
1 Bistro 0.10
2 Dessert Shop 0.07
3 Coffee Shop 0.07
4 Museum 0.07
5 Southern / Soul Food Restaurant 0.07
6 Gourmet Shop 0.03
7 Bar 0.03
8 Cosmetics Shop 0.03
9 Persian Restaurant 0.03
----Paradise Park----
venue freq
0 Park 0.10
1 Chinese Restaurant 0.10
2 Korean Restaurant 0.07
3 Bakery 0.07
4 Fast Food Restaurant 0.07
5 Hotpot Restaurant 0.03
6 Café 0.03
7 Shipping Store 0.03
8 Cosmetics Shop 0.03
9 Pizza Place 0.03
----Parkside----
venue freq
0 Golf Course 0.12
1 Bowling Alley 0.06
2 Salon / Barbershop 0.06
3 Brewery 0.06
4 Business Service 0.06
5 Shopping Plaza 0.06
6 Grocery Store 0.06
7 Chinese Restaurant 0.06
8 Locksmith 0.06
9 Liquor Store 0.06
----Pine Gardens----
venue freq
0 Discount Store 0.08
1 Park 0.08
2 Building 0.08
3 Golf Course 0.08
4 Furniture / Home Store 0.08
5 Bar 0.08
6 Food 0.08
7 Seafood Restaurant 0.08
8 Liquor Store 0.08
9 Clothing Store 0.08
----Poplar Place----
venue freq
0 Baseball Field 1.0
1 Yoga Studio 0.0
2 Metro Station 0.0
3 Middle Eastern Restaurant 0.0
4 Mobile Phone Shop 0.0
5 Moving Target 0.0
6 Multiplex 0.0
7 Museum 0.0
8 New American Restaurant 0.0
9 Nightclub 0.0
----Ridgewood----
venue freq
0 Pizza Place 0.07
1 American Restaurant 0.07
2 Café 0.07
3 Pharmacy 0.07
4 Sandwich Place 0.07
5 Italian Restaurant 0.03
6 Southern / Soul Food Restaurant 0.03
7 Smoothie Shop 0.03
8 Shopping Plaza 0.03
9 Caribbean Restaurant 0.03
----Rivers End----
venue freq
0 Intersection 0.29
1 Cosmetics Shop 0.29
2 Fast Food Restaurant 0.14
3 Playground 0.14
4 Bookstore 0.14
5 Yoga Studio 0.00
6 Mobile Phone Shop 0.00
7 Moving Target 0.00
8 Multiplex 0.00
9 Museum 0.00
----Rose Dhu----
venue freq
0 Campground 1.0
1 Yoga Studio 0.0
2 Outdoors & Recreation 0.0
3 Middle Eastern Restaurant 0.0
4 Mobile Phone Shop 0.0
5 Moving Target 0.0
6 Multiplex 0.0
7 Museum 0.0
8 New American Restaurant 0.0
9 Nightclub 0.0
----Savannah Gardens----
venue freq
0 Convenience Store 0.22
1 Park 0.22
2 Golf Course 0.11
3 Seafood Restaurant 0.11
4 Food 0.11
5 Bar 0.11
6 Liquor Store 0.11
7 Yoga Studio 0.00
8 Optical Shop 0.00
9 Moving Target 0.00
----Savannah State University----
venue freq
0 Harbor / Marina 0.4
1 Seafood Restaurant 0.2
2 Sporting Goods Shop 0.2
3 American Restaurant 0.2
4 Outdoors & Recreation 0.0
5 Middle Eastern Restaurant 0.0
6 Mobile Phone Shop 0.0
7 Moving Target 0.0
8 Multiplex 0.0
9 Museum 0.0
----Shirley Park----
venue freq
0 Chinese Restaurant 0.17
1 Intersection 0.08
2 Bakery 0.08
3 Discount Store 0.08
4 Park 0.08
5 Seafood Restaurant 0.08
6 Gas Station 0.08
7 Sports Bar 0.08
8 Supermarket 0.08
9 Dessert Shop 0.08
----South Garden----
venue freq
0 Candy Store 0.10
1 Plaza 0.07
2 Southern / Soul Food Restaurant 0.07
3 Lounge 0.07
4 Hotel 0.07
5 Gourmet Shop 0.07
6 Seafood Restaurant 0.03
7 Boutique 0.03
8 Dive Bar 0.03
9 Museum 0.03
----Southover----
venue freq
0 Bakery 0.25
1 Brewery 0.25
2 Discount Store 0.25
3 Construction & Landscaping 0.25
4 Yoga Studio 0.00
5 Moving Target 0.00
6 Multiplex 0.00
7 Museum 0.00
8 New American Restaurant 0.00
9 Nightclub 0.00
----Sunset Park----
venue freq
0 Sports Bar 0.07
1 Pizza Place 0.07
2 Discount Store 0.07
3 Fast Food Restaurant 0.07
4 Pharmacy 0.07
5 Fried Chicken Joint 0.07
6 Coffee Shop 0.07
7 Chinese Restaurant 0.03
8 Mobile Phone Shop 0.03
9 Breakfast Spot 0.03
----Sylvan Terrace----
venue freq
0 Harbor / Marina 0.50
1 Boat or Ferry 0.25
2 Scenic Lookout 0.25
3 Optical Shop 0.00
4 Mexican Restaurant 0.00
5 Middle Eastern Restaurant 0.00
6 Mobile Phone Shop 0.00
7 Moving Target 0.00
8 Multiplex 0.00
9 Museum 0.00
----Thomas Square----
venue freq
0 Pub 0.2
1 Business Service 0.2
2 River 0.2
3 Pharmacy 0.2
4 Gourmet Shop 0.2
5 Middle Eastern Restaurant 0.0
6 Mobile Phone Shop 0.0
7 Moving Target 0.0
8 Multiplex 0.0
9 Museum 0.0
----Tremont Park----
venue freq
0 Construction & Landscaping 0.15
1 Gas Station 0.15
2 Discount Store 0.15
3 Convenience Store 0.08
4 Fast Food Restaurant 0.08
5 Grocery Store 0.08
6 Deli / Bodega 0.08
7 Wine Bar 0.08
8 Intersection 0.08
9 Food 0.08
----Victory Heights----
venue freq
0 Pizza Place 0.07
1 Pharmacy 0.07
2 Fast Food Restaurant 0.07
3 Coffee Shop 0.07
4 Mobile Phone Shop 0.07
5 Chinese Restaurant 0.07
6 General Travel 0.03
7 Grocery Store 0.03
8 Sports Bar 0.03
9 Donut Shop 0.03
----Victory Manor----
venue freq
0 Pizza Place 0.07
1 Mexican Restaurant 0.07
2 Sandwich Place 0.07
3 Chinese Restaurant 0.07
4 Coffee Shop 0.07
5 Greek Restaurant 0.03
6 Fried Chicken Joint 0.03
7 Gym / Fitness Center 0.03
8 Grocery Store 0.03
9 Breakfast Spot 0.03
----Victory Square----
venue freq
0 Pizza Place 0.07
1 Pharmacy 0.07
2 Fast Food Restaurant 0.07
3 Coffee Shop 0.07
4 Mobile Phone Shop 0.07
5 Chinese Restaurant 0.07
6 General Travel 0.03
7 Grocery Store 0.03
8 Sports Bar 0.03
9 Donut Shop 0.03
----West Savannah----
venue freq
0 Discount Store 0.25
1 Supermarket 0.12
2 BBQ Joint 0.12
3 Ice Cream Shop 0.12
4 Sandwich Place 0.12
5 Grocery Store 0.12
6 Pizza Place 0.12
7 Kitchen Supply Store 0.00
8 Paper / Office Supplies Store 0.00
9 Multiplex 0.00
----Windsor Forest----
venue freq
0 Intersection 0.08
1 BBQ Joint 0.08
2 Pizza Place 0.08
3 Convenience Store 0.08
4 Sandwich Place 0.08
5 Fast Food Restaurant 0.08
6 Building 0.08
7 Gas Station 0.08
8 Mediterranean Restaurant 0.08
9 Grocery Store 0.08
----Winter Gardens----
venue freq
0 Pool 0.25
1 Soccer Field 0.25
2 Video Game Store 0.25
3 Gym 0.25
4 Optical Shop 0.00
5 Middle Eastern Restaurant 0.00
6 Mobile Phone Shop 0.00
7 Moving Target 0.00
8 Multiplex 0.00
9 Museum 0.00
----Yamacraw Village----
venue freq
0 Museum 0.10
1 Plaza 0.10
2 Dessert Shop 0.07
3 Hotel 0.07
4 Tourist Information Center 0.07
5 Lounge 0.03
6 Southern / Soul Food Restaurant 0.03
7 Café 0.03
8 Brewery 0.03
9 Gourmet Shop 0.03
num_top_venues = 10
for hood in A_grouped['Neighborhood']:
print("----"+hood+"----")
temp = A_grouped[A_grouped['Neighborhood'] == hood].T.reset_index()
temp.columns = ['venue','freq']
temp = temp.iloc[1:]
temp['freq'] = temp['freq'].astype(float)
temp = temp.round({'freq': 2})
print(temp.sort_values('freq', ascending=False).reset_index(drop=True).head(num_top_venues))
print('\n')
----Arlington----
venue freq
0 Video Store 0.09
1 ATM 0.04
2 Gas Station 0.04
3 Convenience Store 0.04
4 Sandwich Place 0.04
5 Restaurant 0.04
6 Discount Store 0.04
7 Donut Shop 0.04
8 Fried Chicken Joint 0.04
9 Nightclub 0.04
----Avondale----
venue freq
0 Smoke Shop 0.08
1 Pizza Place 0.08
2 Mexican Restaurant 0.04
3 Chinese Restaurant 0.04
4 Coffee Shop 0.04
5 Park 0.04
6 Sports Bar 0.04
7 Gaming Cafe 0.04
8 Brewery 0.04
9 Breakfast Spot 0.04
----Belfort Station----
venue freq
0 Sandwich Place 0.11
1 IT Services 0.11
2 Hotel 0.11
3 Italian Restaurant 0.06
4 Gas Station 0.06
5 Chinese Restaurant 0.06
6 Cocktail Bar 0.06
7 Mexican Restaurant 0.06
8 Gym 0.06
9 Gym / Fitness Center 0.06
----Brooklyn----
venue freq
0 Café 0.10
1 Park 0.07
2 Deli / Bodega 0.07
3 Burrito Place 0.03
4 Smoothie Shop 0.03
5 Gay Bar 0.03
6 Construction & Landscaping 0.03
7 Grocery Store 0.03
8 Burger Joint 0.03
9 Gym 0.03
----Church District----
venue freq
0 Pizza Place 0.08
1 Salon / Barbershop 0.08
2 Japanese Restaurant 0.08
3 Grocery Store 0.08
4 Chinese Restaurant 0.04
5 Shopping Mall 0.04
6 Shop & Service 0.04
7 Shipping Store 0.04
8 Sandwich Place 0.04
9 Restaurant 0.04
----Downtown----
venue freq
0 Coffee Shop 0.10
1 Steakhouse 0.07
2 Art Gallery 0.07
3 Café 0.07
4 Lounge 0.07
5 Sandwich Place 0.03
6 Burrito Place 0.03
7 Speakeasy 0.03
8 Comfort Food Restaurant 0.03
9 Concert Hall 0.03
----East Jacksonville----
venue freq
0 Fast Food Restaurant 0.38
1 Video Store 0.12
2 Train Station 0.12
3 Sandwich Place 0.12
4 Light Rail Station 0.12
5 Bakery 0.12
6 ATM 0.00
7 Pet Store 0.00
8 Nightclub 0.00
9 Other Great Outdoors 0.00
----Empire Point----
venue freq
0 Gas Station 0.17
1 Donut Shop 0.17
2 Rental Car Location 0.17
3 Baseball Field 0.17
4 Lawyer 0.17
5 American Restaurant 0.17
6 Plaza 0.00
7 Playground 0.00
8 Pizza Place 0.00
9 Photography Studio 0.00
----Mandarin----
venue freq
0 Business Service 0.29
1 Electronics Store 0.14
2 Volleyball Court 0.14
3 Food Truck 0.14
4 Park 0.14
5 Pet Store 0.14
6 ATM 0.00
7 Other Great Outdoors 0.00
8 Outdoors & Recreation 0.00
9 Pharmacy 0.00
----North Jacksonville----
venue freq
0 Fast Food Restaurant 0.38
1 Video Store 0.12
2 Train Station 0.12
3 Sandwich Place 0.12
4 Light Rail Station 0.12
5 Bakery 0.12
6 ATM 0.00
7 Pet Store 0.00
8 Nightclub 0.00
9 Other Great Outdoors 0.00
----Oakland----
venue freq
0 Bar 0.10
1 Rental Car Location 0.07
2 Park 0.07
3 Convenience Store 0.07
4 Tennis Court 0.03
5 Grocery Store 0.03
6 General Entertainment 0.03
7 Sports Bar 0.03
8 Café 0.03
9 Burrito Place 0.03
----Ortega----
venue freq
0 Harbor / Marina 0.29
1 American Restaurant 0.14
2 Home Service 0.14
3 Trail 0.14
4 Park 0.14
5 Jewelry Store 0.14
6 Pharmacy 0.00
7 New American Restaurant 0.00
8 Nightclub 0.00
9 Other Great Outdoors 0.00
----River Park----
venue freq
0 Coffee Shop 0.10
1 Art Gallery 0.07
2 Café 0.07
3 Dessert Shop 0.03
4 Sushi Restaurant 0.03
5 Food Truck 0.03
6 Dog Run 0.03
7 Pub 0.03
8 Sandwich Place 0.03
9 Convenience Store 0.03
----Riverside----
venue freq
0 Restaurant 0.07
1 Sandwich Place 0.07
2 American Restaurant 0.07
3 Sushi Restaurant 0.07
4 Bar 0.07
5 Coffee Shop 0.07
6 Grocery Store 0.03
7 Spa 0.03
8 Taco Place 0.03
9 Gym 0.03
----San Marco----
venue freq
0 Coffee Shop 0.10
1 American Restaurant 0.07
2 Sandwich Place 0.07
3 Mediterranean Restaurant 0.07
4 Indie Movie Theater 0.03
5 Park 0.03
6 Café 0.03
7 Speakeasy 0.03
8 Sporting Goods Shop 0.03
9 Donut Shop 0.03
----Sherwood Forest----
venue freq
0 Discount Store 0.5
1 Gift Shop 0.5
2 ATM 0.0
3 Pet Store 0.0
4 New American Restaurant 0.0
5 Nightclub 0.0
6 Other Great Outdoors 0.0
7 Outdoors & Recreation 0.0
8 Park 0.0
9 Pharmacy 0.0
----South Jacksonville----
venue freq
0 Hotel 0.07
1 Coffee Shop 0.07
2 Mexican Restaurant 0.07
3 Sandwich Place 0.07
4 Mediterranean Restaurant 0.07
5 Brewery 0.03
6 Café 0.03
7 Sports Bar 0.03
8 Cocktail Bar 0.03
9 Gym / Fitness Center 0.03
----South Side----
venue freq
0 Park 0.14
1 Salon / Barbershop 0.09
2 Baseball Field 0.09
3 Pizza Place 0.09
4 Japanese Restaurant 0.05
5 Grocery Store 0.05
6 Soccer Field 0.05
7 Disc Golf 0.05
8 Chinese Restaurant 0.05
9 Supplement Shop 0.05
----Springfield----
venue freq
0 Zoo 0.2
1 Auto Workshop 0.2
2 Exhibit 0.2
3 Tea Room 0.2
4 Deli / Bodega 0.2
5 Italian Restaurant 0.0
6 Japanese Restaurant 0.0
7 Rental Car Location 0.0
8 Record Shop 0.0
9 Pub 0.0
----Stadium District----
venue freq
0 Pizza Place 0.14
1 ATM 0.07
2 Stadium 0.07
3 Outdoors & Recreation 0.07
4 General Entertainment 0.07
5 Fast Food Restaurant 0.07
6 Baseball Field 0.07
7 Gym 0.07
8 Coffee Shop 0.07
9 Shipping Store 0.07
----Waterleaf----
venue freq
0 Hot Dog Joint 0.17
1 Intersection 0.17
2 Pool 0.17
3 Photography Studio 0.17
4 Gym 0.17
5 Rest Area 0.17
6 Italian Restaurant 0.00
7 Nightclub 0.00
8 Record Shop 0.00
9 Pub 0.00
----West Jacksonville----
venue freq
0 Caribbean Restaurant 0.14
1 Intersection 0.14
2 Home Service 0.14
3 Cosmetics Shop 0.14
4 Sandwich Place 0.14
5 Construction & Landscaping 0.14
6 Cafeteria 0.14
7 ATM 0.00
8 Park 0.00
9 Pet Store 0.00
from IPython.display import Image
Queens=Image(filename='/home/jovyan/demo/JHU_COVID-19_Queens.png')
Queens
Duval=Image(filename='/home/jovyan/demo/JHU_COVID-19_Duval.png')
Duval
Chatham=Image(filename='/home/jovyan/demo/JHU_COVID-19_Chatham.png')
Chatham